Registered aircraft · 18,495

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.

N9243QFlegler Barry Bronson · Eagle, MIBuilt 1970 · S/N D-9243 N9243RC & L Holzwarth Inc · Virden, ILBuilt 1975 · S/N 18802181T N9249RGreat Plains Applications LLC · Slayton, MNBuilt 1975 · S/N 18802187T N924ALCom Air LLC · Jackson, MOBuilt 2006 · S/N 29-0426 N924CDSunshine Holding LLC · Danbury, CTBuilt 2002 · S/N 0334 N924CTGo South LLC · Ruleville, MSBuilt 1979 · S/N CE-889 N924DKSky Captain LLC · Coldwater, MSBuilt 2013 · S/N E-4009 N924KGHairston Hollie Brenton · Bryan, TXBuilt 1979 · S/N E1507 N924RBHitendra Chaturvedi · Chandler, AZBuilt 1979 · S/N E-1612 N924RHSmith Joelene K · Avon, INBuilt 1978 · S/N E-1288 N924VBauman Ronald L · Stuttgart, ARBuilt 1974 · S/N D-9702 N924WOcean Isle Aviation LLC · Ocean Isle Beach, NCBuilt 2001 · S/N 0048 N924Y924y LLC · Visalia, CABuilt 1998 · S/N E-3198 N92503Harper Bryan K · Junction City, ORBuilt 1976 · S/N 18503155 N9252RBank Of Utah Trustee · Salt Lake City, UTBuilt 1975 · S/N 18802189T N9253QN9253q LLC · Goldsby, OKBuilt 1971 · S/N D-9253 N9257QC9 Aero LLC · Gothenburg, NEBuilt 1971 · S/N E-277 N92593Snider Scott E DBA · Turner, MTBuilt 1975 · S/N 18802067T N925BKAcom Electronic Measurement Technology Inc · Milpitas, CABuilt 1976 · S/N 0117 N925CPoms Scott H · San Mateo, CABuilt 1977 · S/N E-1057 N925KDBenson Thomas W Trustee · Weston, MABuilt 2005 · S/N 1673 N925LRRedwood Air LLC · San Francisco, CABuilt 2013 · S/N E-3993 N925MVan Wylen Mary F · Grand Rapids, MIBuilt 1973 · S/N D-9474 N925MRElectra Boone Aviation LLC · Dallas, TXBuilt 2007 · S/N E-3753 N925MSBargfrede Bernard Trustee · Blackburn, MOBuilt 2002 · S/N 0342 N925PCLee Investment Services LLC · Madisonville, TXBuilt 2005 · S/N 1633 N925PDC2 Aviation LLC · De Soto, KSBuilt 2005 · S/N 1270 N925PWN37gd LLC · Fort Myers, FLBuilt 2001 · S/N 0122 N925RCCastle Shelter Group LLC · Clearwater, MNBuilt 1969 · S/N D-9001 N925RJHammer Neil A · Alexandria, MNBuilt 2002 · S/N 40048 N925SFPeifer Charles R · Albuquerque, NMBuilt 2009 · S/N E-3914 N925SLInnovative Aviation LLC · Deatsville, ALBuilt 1976 · S/N E-938 N925TPreserve Land Company LLC · Franklin Lakes, NJBuilt 1964 · S/N D-7371 N925TPKtm Projects LLC · Durant, OKBuilt 1976 · S/N TJ-35 N925WMVaughn Aviation LLC · Lowell, ARBuilt 1979 · S/N U20604997 N9260QToomey Neal P · Huntington Beach, CABuilt 1971 · S/N CE-348 N9261GAllred Bobby A · Centre, ALBuilt 1973 · S/N 18801441 N9262QPrince John Curtis III · Frierson, LABuilt 1971 · S/N CE-320 N9264RAir Dakota Flite Inc · Hettinger, NDBuilt 1975 · S/N 18802196T N9266QDecastro Susan · Westborough, MABuilt 1972 · S/N TE-861 N9268QWeyhmuller Luke · Chapin, SCBuilt 1971 · S/N E-279 N926BTTelematic Systems Inc · North Fort Myers, FLBuilt 1977 · S/N TE-1110 N926CDZimmerman Aircraft Rentals Inc · Friedens, PABuilt 2002 · S/N 0351 N926DCTt Aviation LLC · Henderson, TXS/N 0926 N926HMWestern Enterprise LLC · Pueblo, COBuilt 1974 · S/N 18502422 N926LCDkj Inc · Reno, NVS/N E-3908 N926LTHall Richard M · Scotland, SDBuilt 1968 · S/N 188-0347 N926MTNew London Aviation LLC · Forest, VABuilt 1978 · S/N 421C0625 N92701Kyllo Jeffrey K · Larimore, NDBuilt 1975 · S/N 18802070T N92711Intergard R&D LLC · Miami, FLBuilt 1973 · S/N 21060024

Back to AD 86-13-04 R3