Registered aircraft · 25,369

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N7100GBoyd John J · Wasilla, AKBuilt 1969 · S/N 17258800 N7100UTeerlink Randall Spencer · Hanover, VABuilt 1964 · S/N 2730 N7101GBowhawk LLC · Ocala, FLBuilt 1969 · S/N 17258801 N7101UJucha Raymond A · Mount Dora, FLBuilt 1964 · S/N 2731 N7101VEquus All American LLC · Midwest City, OKBuilt 1974 · S/N 20-0025 N7102GBarbosa Manuel · Apple Valley, MNBuilt 1969 · S/N 17258802 N7102QJuckett Jimmy L · Springhill, LABuilt 1972 · S/N 17260402 N7103GMountain Flyers Inc · Hendersonville, NCBuilt 1969 · S/N 17258803 N7103VLennartson Gerald J · Greensboro, NCBuilt 1974 · S/N 20-0027 N7104GAir Carriage LLC · Chico, CABuilt 1969 · S/N 17258804 N7104VPorzillo Patrick H · Newburg, MDBuilt 1974 · S/N 200028 N7105UMolter Roy G · Shelbyville, INBuilt 1964 · S/N 2735 N7105VCromwell James T · Hamilton, MTBuilt 1974 · S/N 21-0039 N7106UTappon Wayne A · Ladysmith, WIBuilt 1964 · S/N 2736 N7106VMcatee Von · Houston, TXBuilt 1974 · S/N 21-0040 N7107UJohnson Kenneth D · Camdenton, MOBuilt 1964 · S/N 2765 N7108GLakes Area Aviation LLC · Little Falls, MNS/N 17258808 N7108QAnderson Michael · Hillsboro, NDBuilt 1972 · S/N 17260408 N7109QLawless Bruce A · Lago Vista, TXBuilt 1972 · S/N 17260409 N7109UOyler Joseph B · Kokomo, INBuilt 1964 · S/N 2739 N710FGKimbrell Jeffrey L · Greenville, SCBuilt 1970 · S/N 177RG0016 N710TLBarker John Van · Smyrna, GABuilt 2007 · S/N 1398-2007 N7110QLawson Virgil · Sylvar Grove, KSS/N 17260410 N7111NAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1977 · S/N 17269101 N7112GHooper Walter E III · Spring City, TNBuilt 1969 · S/N 17258812 N7113QMiles Michael G · Hillsborough, NCBuilt 1972 · S/N 17260413 N7114QSass Kenneth · Charlotte, NCBuilt 1972 · S/N 17260414 N7114UMaximizing Abilities Through Training Two DBA · Independence, MOBuilt 1964 · S/N 356 N7114VCross Wings Aviation LLC · San Antonio, TXBuilt 1974 · S/N 22-0049 N7115QMaggart Kenneth R · Lutz, FLBuilt 1972 · S/N 17260415 N7116QStogner Sarah E · Monahans, TXBuilt 1972 · S/N 17260416 N7116VPeterson Robert E · Mobile, ALBuilt 1974 · S/N 20-0029 N7117GBaker Brady B · South Hero, VTBuilt 1969 · S/N 17258817 N7117VNrv Flyers Inc · Blacksburg, VABuilt 1974 · S/N 20-0030 N7118QMartin Stephen T · Green Cove Springs, FLBuilt 1972 · S/N 17260418 N7119VMark Youngblood Pa · Naples, FLBuilt 1974 · S/N 21-0042 N711BCSummit Air One Inc · Wilmington, DEBuilt 2024 · S/N 638-2024 N711BGSaybrook Offshore LLC · Guilford, CTBuilt 1982 · S/N P21000806 N711DFFly Mooney LLC · Phoenix, AZS/N 2532 N711DQNtx Citabria LLC · Wichita Falls, TXBuilt 1975 · S/N 558-76 N711DTMcclellion W Richard · Anderson, SCBuilt 1979 · S/N R18201061 N711EZSparrow International LLC · Littleton, COBuilt 1977 · S/N R18200135 N711GTRadcliff Charles · Las Vegas, NVBuilt 1969 · S/N 17258811 N711HEDesert West Enterpises LLC · Roswell, NMBuilt 1979 · S/N P21000242 N711JJReady Aim Flyer LLC · New Castle, DEBuilt 1979 · S/N 1139-79 N711LPJohnson Tommy A · Grand Junction, COBuilt 1964 · S/N 2872 N711NFSkywarrior Flight Training Inc · Pensacola, FLBuilt 1984 · S/N 17276196 N711PDBrown Richard K · East Falmouth, MAS/N R18201282 N711PTTaylor Stephen N · Punta Gorda, FLBuilt 1976 · S/N 0731 N711RNGoldsmith Donald E Jr · Brandywine, MDBuilt 1973 · S/N 17702010

Back to AD 80-25-07 R1