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.

N1054DBrown Douglas R · Centralia, WABuilt 1951 · S/N 7666 N1055MRyan Michael W · Long Beach, CABuilt 1975 · S/N 18264217 N1056DSmooth Landings LLC · Magee, MSBuilt 1951 · S/N 7668 N1057DMedore Douglas A · Romoland, CAS/N 7669 N1057TMclane Trailer Sales Inc · Poplar Bluff, MOBuilt 2005 · S/N 18281572 N1058DMorley Philip · Manhattan Beach, CABuilt 1951 · S/N 7670 N105AAWehrmacher James P · Crawford, COBuilt 1978 · S/N R18200483 N105DFWestwood Aero Inc · Porterville, CABuilt 1986 · S/N 21064999 N105JMBullard Roy P · Granbury, TXBuilt 2006 · S/N 18281743 N105MTRegistered aircraftBuilt 1976 · S/N 182-64338 N105SPDepartment Of Emergency Svcs & Public Protection · Hartford, CTBuilt 1984 · S/N 18268425 N105VBHughes Francis A · Ltl Egg Hbr Twp, NJBuilt 1981 · S/N 18268138 N1061PRemote Properties LLC · Anchorage, AKBuilt 1983 · S/N U20606773 N1065UKloker Daniel E · Owasso, OKS/N 18281573 N1065VRegistered aircraftBuilt 1974 · S/N U20602435 N10662Momin Ahmed H · Sugar Land, TXBuilt 2005 · S/N 18281577 N1067MShore Enterprises Of Gainesville LLC · Gainesville, FLBuilt 1970 · S/N 21059367 N1068DReid James D · Thomasville, NCBuilt 1951 · S/N 7680 N1069DPrescott Scot · Alburgh, VTBuilt 1951 · S/N 7681 N1069LWilson Michael A · Everett, WABuilt 1956 · S/N 33633 N106PSScarrow James D · Jerome, IDBuilt 1976 · S/N 18264800 N106RGCadena Edward R Jr · Houston, TXBuilt 1966 · S/N 18257535 N106UMiha LLC · Dover, DEBuilt 1956 · S/N 32325 N1071DWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1951 · S/N 7683 N1071MJesperson Kenneth R · Ekalaka, MTBuilt 1969 · S/N T210-0451 N1072DRegistered aircraftS/N 7684 N1073MScr Aviation LLC · Austin, TXBuilt 1975 · S/N 18264219 N1074CZata Group LLC · North Little Rock, ARBuilt 2005 · S/N 18281690 N1074DBarron Aviation LLC · Perry, MOBuilt 1951 · S/N 7686 N1074XKelley Air LLC · Milford, MIBuilt 2005 · S/N 20608233 N1075DBrundage Donald J Jr · Green Cove Springs, FLBuilt 1951 · S/N 7687 N1077DBarron Aviation LLC · Perry, MOS/N 7689 N107JPPayne Thomas E · Old Forge, NYBuilt 1973 · S/N U20602079 N107PFConant Dakotah · Ocala, FLBuilt 1998 · S/N 18280220 N107RHHenderson Robert T Jr · Sunny Isles Beach, FLBuilt 1977 · S/N R18200093 N107SPDepartment Of Emergency Svc & Public Protection · Hartford, CTBuilt 1984 · S/N 18268427 N107WFWilcox Farms Inc · Roy, WABuilt 1961 · S/N 18253149 N1080DLindsey Paul Robert · Quinlan, TXBuilt 1951 · S/N 7692 N1080MFlying Particles Inc · Livermore, CABuilt 1977 · S/N 18266034 N1081DMilton William H · Amsterdam, NYBuilt 1951 · S/N 7693 N1082DSimonye Curtis F · Holmes Beach, FLBuilt 1951 · S/N 7694 N1082PGarrett James D Jr Trustee · Coolidge, AZBuilt 1968 · S/N 18258855 N1083VWoltering Myron B · Granite Bay, CABuilt 1974 · S/N U20602453 N1085MDuncan Terry C Trustee · Cupertino, CABuilt 1975 · S/N 18264221 N1086LLade Burton G · Bemidji, MNBuilt 1959 · S/N 50564 N1086MSargent John E · Vancouver, WABuilt 1975 · S/N 18264222 N1089MPetersen Clayton · Albert Lea, MNBuilt 1975 · S/N 18264223 N108CTDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608212 N108EENorthwood Services Inc · Skwentna, AKBuilt 1956 · S/N 32505 N108GWPope James D · Clarkston, WAS/N 32683

Back to AD 84-10-01 R1