Skip to content

Registered aircraft · 20,486

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:84-10-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:84-10-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:84-10-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:84-10-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:84-10-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:84-10-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.

N1251SPt Air LLC · Madison, WIBuilt 1976 · S/N 18264820 N1252EStedje Timothy M · Gruver, TXBuilt 1999 · S/N 18280580 N1252MNyquist David · Boulder, COBuilt 1975 · S/N 18264259 N1253SHale Jeffrey D · Reno, NVBuilt 1976 · S/N 18264822 N1254SStewart Donald K · Holbrook, MABuilt 1976 · S/N 18264823 N1255MCammack Lockwood P · Mount Pleasant, TXBuilt 1975 · S/N 18264261 N1255VHanson Lanny Lane · Polson, MTBuilt 1974 · S/N U20602540 N1256SBrant P Rouse Dds Plc · Tahlequah, OKBuilt 1976 · S/N 18264825 N1257P812 Aviation LLC · Salem, INBuilt 2022 · S/N 18283193 N1257SKidd Bryce · Clovis, NMBuilt 1976 · S/N 18264826 N12580White River Ag Spraying Llp · Newport, ARBuilt 1964 · S/N 18051458 N125BMBaron Transporation Services LLC · Destrehan, LABuilt 1978 · S/N 21062926 N125CFInternational Air Services Inc Trustee · Carson City, NVS/N 21064253 N125JABillmans Inc · Cut Bank, MTBuilt 2005 · S/N 18281527 N125KCOtto Pilot Aviation LLC · Midland City, ALBuilt 1982 · S/N R18201805 N125LGWheat Travis W · Henderson, NVS/N 18280070 N125MDMaryland Aviation Administration · Bwi Airport, MDBuilt 2000 · S/N 20608099 N125MWMishler Kenneth C · Lawrence, KSBuilt 1973 · S/N 18262211 N125PBEvergreen Financial Investments LLC · Wayzata, MNBuilt 1977 · S/N 18265348 N125SLSlingshot Aviation LLC · Chandler, AZBuilt 2003 · S/N 18281253 N125TLPease Lynn A · Elizabeth, ILS/N 18255291 N125WAHorton Kelly · Hollis, OKBuilt 1975 · S/N 18263594 N125WWKapotes Nicholas Stephan · Pompton Plains, NJBuilt 1998 · S/N 18280348 N1261SRed Arrows Aviation LLC · Lakeway, TXBuilt 1976 · S/N 18264829 N1262MRtw Aviation LLC · Fort Lauderdale, FLBuilt 1975 · S/N 18264265 N1262SSopatyk Brian D · Boise, IDBuilt 1976 · S/N 18264830 N1263SAlabama Law Enforcement Agency · Montgomery, ALBuilt 1976 · S/N 18264831 N1265SColeman Douglas · Ocean Springs, MSBuilt 1976 · S/N 18264833 N1266SBarton Jonathan E · Tehachapi, CABuilt 1976 · S/N 18264834 N12675Van Bortel Aircraft Inc · Arlington, TXBuilt 2007 · S/N 18282026 N1267SWhitmore James W · Grass Valley, CABuilt 1976 · S/N 18264835 N1268MHuffer Tyle · Kenansville, NCBuilt 1975 · S/N 18264266 N1269MEagle High Properties LLC · Calhoun, LABuilt 1975 · S/N 18264267 N1269SMriaudio Inc · Carlsbad, CAS/N 18264837 N126AKRohl Shirley J · Anchorage, AKBuilt 1957 · S/N 32772 N126JCGebler Laurence W · Ellerbe, NCBuilt 1979 · S/N 18267134 N126JDEastland Aviation Inc · Midland, TXBuilt 1942 · S/N 7802 N126LCBeylund David L · Macon, GABuilt 1950 · S/N 7632 N126LSMerritt Aaron S · Manhattan, MTS/N 21062038 N126MPSorensen P Grahame · Salt Lake City, UTBuilt 1974 · S/N 18262809 N126MSNance Cattle Co · Birney, MTBuilt 1964 · S/N 18051373 N126NXCombs Nicholas E · League City, TXBuilt 1951 · S/N 7858 N126SWollaston Dean E · Hazel Green, WIBuilt 1956 · S/N 33285 N1272SAfrican Parks Aviation Inc Trustee · Cheyenne, WYBuilt 1976 · S/N 18264840 N12730Silver Creek Aviation Services · Fort Worth, TXBuilt 2007 · S/N 20608302 N1274MGarner Tom Trustee · Agua Dulce, CABuilt 1975 · S/N 18264271 N1274SDiamond E Electrical Services LLC · Bryant, ARBuilt 1976 · S/N 18264842 N1278SSac Exec LLC · Sacramento, CABuilt 1976 · S/N 18264846 N1279MSturdy Wings Aviation LLC · Mcpherson, KSBuilt 1975 · S/N 18264272 N1279SCavu Aviation LLC · Haiku, HIBuilt 1976 · S/N 18264847

Back to AD 84-10-01 R1