Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N328MBN328mb LLC · Old Bridge, NJBuilt 2004 · S/N 0867 N328PStrother J Barron · Santa Rosa Beach, FLBuilt 1999 · S/N TH-1916 N328PMMayworm Patrick · Mclean, VABuilt 2022 · S/N 3RX116 N328RHEchemendia Joel · Kissimmee, FLBuilt 2004 · S/N 1008 N328SFast Flight Inc · Springdale, ARBuilt 1969 · S/N D-9068 N3292MHyannis Air Service Inc · Hyannis, MAS/N 402C0304 N3296PMadlener Michael J · Pahrump, NVBuilt 1996 · S/N ES-003 N329CBullard Aviation Services Inc · Ormond Beach, FLBuilt 1973 · S/N CE-444 N329JHAlliance Aircraft Sales Inc · Pierre, SDBuilt 1976 · S/N E-870 N329RTRegistered aircraftBuilt 1972 · S/N D-9343 N329XLima 2 Aviation Of Mississippi LLC · Bogue Chitto, MSBuilt 1964 · S/N D-7509 N32BHBechtold Brahm Hellman · Parker, COBuilt 1977 · S/N D-10046 N32BLHeiser And Associates Inc · Novato, CABuilt 1982 · S/N EA-296 N32GRAngella Tony · Fort Lauderdale, FLBuilt 2001 · S/N 0046 N32HGGlauser Aviation LLC · Houston, TXBuilt 1958 · S/N 461 N32HWStrader John Kelly · Brenham, TXS/N 30-0003 N32MBMarin Airmen Inc · Mill Valley, CABuilt 1969 · S/N E-160 N32MCCook Tracy L · Prosper, TXBuilt 1974 · S/N 21060482 N32NBSteele Kathleen N · Scottsdale, AZBuilt 1990 · S/N CE-1514 N32PPDenison Aviation Inc · Atlantic, IABuilt 1964 · S/N D-7702 N32PXKustatan Leasing LLC · Kenai, AKBuilt 1976 · S/N U20603343 N32RLVb Glass Company Inc · Jamestown, CAS/N U20605551 N32TAVan Wyk Kenneth W · Pella, IABuilt 1968 · S/N E-120 N32TBBoyland Todd · Solon, OHBuilt 1980 · S/N EA-77 N32TLJonesboro Cycle And Atv LLC · Bone, ARBuilt 1974 · S/N 310R0032 N32VSpeer Aviation LLC · Evansville, INBuilt 1977 · S/N 340A0250 N32VSCraftline LLC · Delray Beach, FLS/N 340-0025 N32WHEagle Air Partners LLC · Bartlett, TNBuilt 1977 · S/N E-1184 N3300GAir Amg LLC · Greensboro, NCBuilt 1977 · S/N TH-869 N3304QMcnutt Brian K · Mojave, CAS/N 320D0104 N3308QDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 320D0108 N3308SSutton Aircraft Salvage LLC · Palmer, AKBuilt 1973 · S/N 18502267 N3309QB & R Aerial Crop Care Inc · Connell, WABuilt 1966 · S/N 320D0109 N3309SCessna 210 N3309s LLC · Yellville, ARBuilt 1969 · S/N 21059109 N330CDDec Enterprises LLC · Naples, FLBuilt 2005 · S/N 1319 N330DJPrecision Aviation Specialty Services LLC · Bay Minette, ALBuilt 1992 · S/N CE-1707 N330DPAdvanced Commercial Group LLC · Helena, MTBuilt 2005 · S/N 1417 N330MRJett Aviation LLC · Clovis, NMBuilt 1979 · S/N 340A0721 N330WH2k Partners LLC · Dallas, TXBuilt 1989 · S/N CE-1322 N3311SExperimental Aircraft Association Inc · Oshkosh, WIBuilt 1969 · S/N 21059111 N3312SBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 21059112 N3315QTcf Ventures LLC · Wilmington, DEBuilt 1966 · S/N 320D0115 N3316QPerson Michael · West Chester, PABuilt 1966 · S/N 320D0116 N3317QSkynight 17q LLC · Roseville, CABuilt 1966 · S/N 320D0117 N33189Schrage Rodney L · Steamboat Springs, COBuilt 1975 · S/N U20602659 N3318Q2400 Rickenbacker LLC DBA · Auburn, CABuilt 1966 · S/N 320D0118 N3318RPetersen Family 1999 LLC · Anchorage, AKS/N 18502872 N33196One Niner Six Aviation LLC · Anchorage, AKBuilt 1975 · S/N U20602664 N3319JWelch Cooper · Lee, FLBuilt 1980 · S/N 18803627 N3319QNeuschaefer George H · White Hills, AZBuilt 1966 · S/N 320D0119

Back to AD 86-13-04 R3