Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N1003QKing Jeffrey J · Fort Worth, TXS/N 32R-7780217 N1007LPlane Fun Inc Tr Trustee · Snellville, GAS/N 28R-7703403 N1007XD&R LLC · Emory, TXS/N 34-7570182 N100TCMckinney Richard P · Fayeteville, ARBuilt 1973 · S/N 28R-7335370 N100VFMeridian Aviation N100vf LLC · Mobile, ALBuilt 1977 · S/N 32R-7780539 N1010YGregory Kenneth · Crowley Lake, CABuilt 1970 · S/N 28R-35800 N1012XSunbeam Air Operations LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535215 N1013XBtm Aero LLC · Mansfield, TXS/N 28R-7535216 N1018TLeon J Hapka · Halma, MNS/N 24-4884 N101DHLarson David R · Boerne, TXBuilt 1960 · S/N 24-1833 N101DWInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 32R-7680399 N101JKKaras Dean · Lansing, KSS/N 28R-7335243 N101WCRamey Curtis · Hilton Head Island, SCBuilt 1976 · S/N 32R-7680381 N1020HHw Barnhouse Inc · Vero Beach, FLBuilt 1968 · S/N 30-1569 N1021XO-D LLC · Kalispell, MTBuilt 1975 · S/N 28R-7535219 N1022XLeggett Air LLC · Cairo, GABuilt 1975 · S/N 28R-7535220 N1024U24u Aviation LLC · Wilmington, DEBuilt 1971 · S/N 34-7250004 N102EASteves Atv Services Inc · Oceano, CABuilt 1976 · S/N 32R-7680158 N102EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2002 · S/N 2844081 N102LLExecutive Aviation LLC · Peoria, AZS/N 34-7970483 N1035XSocal Blue Side Up LLC · Anaheim, CABuilt 1975 · S/N 28R-7535222 N1039UIowa Lakes Community College · Estherville, IABuilt 1971 · S/N 34-7250024 N103EAJwp Group LLC · Long Island, MEBuilt 1976 · S/N 32R7780054 N103HPMcfarland Natalie · Roseburg, ORBuilt 1965 · S/N 24-4153 N103PGHnd Operations LLC · Henderson, NVBuilt 1969 · S/N 30-1858 N1040HKing Jay M · Kokomo, INBuilt 1976 · S/N 32R-7780124 N1040UAmerican Aviation Inc · Brooksville, FLS/N 34-7250025 N1041HCentury Flight Systems Inc · Mineral Wells, TXBuilt 1977 · S/N 32R-7780125 N1042UShackleford Developments Of Sc LLC · Mount Pleasant, SCBuilt 1971 · S/N 34-7250026 N1042XN1042x LLC · Papillion, NEBuilt 1975 · S/N 28R-7535223 N1043QRegistered aircraftBuilt 1977 · S/N 28R-7737025 N1043XAustin Security Corp · Battleboro, NCBuilt 1975 · S/N 28R-7535224 N1044HWiebe Farms Inc · Hooker, OKS/N 34-7770100 N1047QTaras Brock DBA · Cedaredge, COBuilt 1977 · S/N 28R-7703049 N104CPN7293l LLC · Waxahachie, TXBuilt 1966 · S/N 30-1276 N104EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2007 · S/N 2844135 N104GKIndigo Bunting Aviation LLC · Morristown, NJBuilt 1977 · S/N 32R7780461 N104JHDouble Helix Solutions LLC · Kamuela, HIS/N 34-7670163 N104WPMartyn Christian A · Hallendale, FLBuilt 1977 · S/N 34-7870048 N1054UDippolito Thaddeus M · Sherwood, ARBuilt 1971 · S/N 34-7250038 N1054XMurphy George E · Robinson, ILBuilt 1975 · S/N 34-7570195 N1056HBrown Danny Joe · Skidmore, MOS/N 28R-7703011 N1057HFrese Albert · Creede, COS/N 32R-7780127 N1063HWalker Db · Rougemont, NCS/N 32R-7780129 N1063QRussell Construction Co · Douglas, WYBuilt 1977 · S/N 32R-7780221 N106ATLichtman Aaron Marcus · Baltimore, MDS/N 32R-7780326 N106JLinder Michael A · Arvada, COBuilt 1961 · S/N 24-2668 N106PESheboygan Flying Club LLC · Sheboygan, WIBuilt 1977 · S/N 28R-7837088 N1070BCurtis Julia A · Holladay, UTBuilt 1964 · S/N 24-3620 N1070XMosby Group LLC · Edgerton, MOBuilt 1975 · S/N 34-7570199

Back to AD 97-01-01 R1