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.

N70506Roesner Liselotte A · Hilton, NYBuilt 1973 · S/N U20602073 N7050NGuy Darrell G · Marietta, GABuilt 1967 · S/N D-8645 N7053NNames Loch K · Eugene, ORBuilt 1967 · S/N D-8646 N70570Miel Del Rio Grande Inc · Monte Vista, COBuilt 1973 · S/N U20602083 N7058NAeroplanes2 LLC · Indianola, IABuilt 1967 · S/N D-8640 N70594Non-Typical Airplanes LLC · Malad City, IDS/N U20602084 N70595Lung Aerial Group Inc · Tustin, CABuilt 1973 · S/N U20602085 N70598Routh Lucas R · Albert Lea, MNFirst renewal noticeBuilt 1973 · S/N U20602087 N705CMtm Investments LLC · Goshen, INBuilt 2002 · S/N 0418 N705CDLearjetjohn Flying Club LLC · Moulton, ALS/N 0005 N705GWFba Aviation LLC · Wildwood, FLBuilt 1991 · S/N TH-1631 N705NCEagle Leasing Inc · Gaylord, MIBuilt 1975 · S/N TH-595 N7066NGeorge Mike J · Springfield, ILBuilt 1967 · S/N CE-190 N7068NWashburn Donald Kevin · Reidsville, NCS/N TE-480 N7069NLindley Robert F · Williamson, GABuilt 1967 · S/N D-8658 N706AAArcher Automotive Inc · Houston, TXBuilt 1981 · S/N 421C1075 N706CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0095 N706NCGaylord Hangers LLC · Gaylord, MIBuilt 1975 · S/N 421C0037 N70712Ivany Hugh Scott · Anchorage, AKBuilt 1976 · S/N 18503059 N70713Satre Olaf · Kiowa, COBuilt 1971 · S/N 18501878 N7072NDesrosiers Stefan · Scotch Plains, NJBuilt 1967 · S/N D-8648 N7073NOlson Steven E · Lakeville, MNBuilt 1967 · S/N D-8650 N7073XUnited States Air Force - Owner · Peterson Afb, COBuilt 1965 · S/N TF-21 N7075NSign Zeppelin LLC · Orlando, FLBuilt 1968 · S/N D-8733 N7079FTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 404-0681 N707ADJwd Aviation LLC · San Luis Obispo, CABuilt 2007 · S/N E-3817 N707AJRandy Goering Inc · Bend, ORBuilt 1979 · S/N E-1499 N707BRCawood William Richard · Mountain Rest, SCBuilt 1966 · S/N D-8312 N707BWDrago Air LLC · Mulberry, INBuilt 1984 · S/N 340A1812 N707DKSunshine Peak LLC · Saint Louis, MOBuilt 2013 · S/N TH-2374 N707DMRegistration Pending · Portland, MERegistration pendingBuilt 1971 · S/N 421B0145 N707DTFresco Toys LLC · Miami, FLBuilt 1973 · S/N 421B0468 N707ERCrossbrook LLC · Willoughby, OHBuilt 1977 · S/N 21062337 N707FFRegistered aircraftBuilt 2008 · S/N E-3818 N707GBAmalong Timothy M · Tucson, AZBuilt 1977 · S/N 310R1229 N707KWWaters Aero Marine Inc · South Thomaston, MEBuilt 1975 · S/N U20602619 N707LHoon David M · Wolf Creek, MTBuilt 1968 · S/N D-8731 N707LAStowers Machinery Corp · Knoxville, TNBuilt 1993 · S/N TH-1685 N707LJFront Row LLC · Los Alamos, NMBuilt 1979 · S/N EA-4 N707MMEaa Aviation Foundation Inc · Oshkosh, WIBuilt 2003 · S/N L2K-221 N707MPEmmet Street Holdings LLC · Saint Petersburg, FLBuilt 1978 · S/N TJ-166 N707PWAtaraxia Aircraft Holdings LLC · Greenville, SCBuilt 1980 · S/N TH-1106 N707RDJones Alonzo · Los Angeles, CABuilt 1974 · S/N D-9708 N707RLApplegate Properties LLC · Morris, ILS/N T303-00008 N707SPWagon Wheel Distributing Inc · Dallas, TXBuilt 1973 · S/N 421B0411 N707TToth Michael · Wadsworth, OHBuilt 1976 · S/N E-861 N707TDWhite Plains Enterprise LLC · Kalispell, MTBuilt 2005 · S/N 1363 N707THFly Boys LLC · Lincoln, NEBuilt 2003 · S/N 0707 N707WGRegistered aircraftBuilt 1968 · S/N E-70 N707WJLandry Don T · Thousand Oaks, CABuilt 1977 · S/N U20604054

Back to AD 86-13-04 R3