Skip to content

Registered aircraft · 5,075

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-19-03-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-19-03-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-19-03-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-19-03-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-19-03-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-19-03-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.

N9294PJensen Thomas · Durango, COBuilt 1968 · S/N 24-4793 N9295GMcavian LLC · Westworth Village, TXBuilt 1997 · S/N 3257017 N9296NSunrider Aviation Inc · Irvine, CABuilt 1997 · S/N 3257013 N9296PStevens John W · Westlake Village, CABuilt 1968 · S/N 24-4795 N9297P9797p LLC · San Angelo, TXBuilt 1968 · S/N 24-4796 N9298DAims Air LLC · Kingsport, TNBuilt 1997 · S/N 3257002 N9299PFusion Flight Management LLC · Lake Havasu City, AZBuilt 1997 · S/N 4636123 N9299XSchoepel Alexandra E Trustee · Templeton, CABuilt 1997 · S/N 3257021 N929DJA And S Flying Services Inc · Bristol, VABuilt 2004 · S/N 3257344 N929RRPanafax LLC · Wilmington, DEBuilt 1997 · S/N 4636115 N92BLIsland Birds Inc · St Thomas, VIS/N 31-7852095 N92DMD & M Flyers LLC · Petoskey, MIBuilt 1978 · S/N 27-7854107 N92ECStevens Faustin R · Kennewick, WABuilt 1977 · S/N 32R-7880007 N92EJSecond Life Properties LLC · Salisbury, MDBuilt 1978 · S/N 32R-7885242 N92GTBlue Skies Aviation LLC · Riverdale, MDBuilt 2002 · S/N 2100 N92HDN242ak LLC · Ocala, FLBuilt 2003 · S/N 3257326 N92HRSweetsholdings LLC · Lewisville, TXBuilt 1970 · S/N 31-649 N92JWKennedy Donald R Jr · New Philadelphia, OHBuilt 1974 · S/N E600 N92LLTanner Dave · Auburn, CABuilt 2000 · S/N 3257191 N9303PDyster Justin C · Coeur D Alene, IDBuilt 1968 · S/N 24-4799 N930KGGriggs Roger · Columbia, SCS/N 32R-8029027 N930MDTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1967 · S/N 27-3787 N930ZMirage 930 Corp Trustee · Wilmington, DEBuilt 1995 · S/N 4622188 N9312PGregory John P · Riverside, CABuilt 1969 · S/N 24-4808 N9313PPencosky Edward A Jr · Manorville, NYBuilt 1969 · S/N 24-4809 N9315PGrady Michael J · Farmington, NMBuilt 1969 · S/N 24-4811 N9316PProvost Stephen Nicholas · Saint Louis, MOBuilt 1969 · S/N 24-4812 N9317PFutter John H · Whately, MABuilt 1969 · S/N 24-4813 N9318PPorter Wayne · Phoenix, AZBuilt 1969 · S/N 24-4814 N931SAMarc Inc · Bolton, MSBuilt 1975 · S/N 317552036 N9321PRegistered aircraftBuilt 1969 · S/N 24-4818 N9325PCody William James · South Lyon, MIBuilt 1969 · S/N 24-4822 N9327PKrb LLC · Rupert, IDBuilt 1969 · S/N 24-4825 N9329PLenders Insurance Solutions Group LLC · Ozark, MOBuilt 1969 · S/N 24-4827 N9331PAmra Nabil · Chaska, MNS/N 24-4829 N9333PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 24-4831 N9338PDream Home Aviation Inc · New Smyrna Beach, FLS/N 24-4836 N9339PBreznik John D · Bradford, PABuilt 1969 · S/N 24-4837 N9342PTaulbee Gregory · Sarasota, FLBuilt 1969 · S/N 24-4840 N9344PWheeler R Tyson · Frederick, MDBuilt 1969 · S/N 24-4843 N9345PRegistration Pending · Gilbert, AZRegistration pendingBuilt 1969 · S/N 24-4844 N9347PRegistered aircraftBuilt 1969 · S/N 24-4846 N93486Ablamis Roger · Los Gatos, CABuilt 1973 · S/N 73-31062 N934PHRossell Holdings LLC · Astoria, ORBuilt 1974 · S/N 32-7540059 N93505Clark Roger D · Lubbock, TXBuilt 1973 · S/N 73-32-120 N9353PSmith Evan B · Mechanicsville, VABuilt 1969 · S/N 24-4854 N93541Gibbs Frederick L · Flagstaff, AZBuilt 1973 · S/N 73-32-126 N93554Pittman Randy L · Morris, ILBuilt 1973 · S/N 74-31074 N9356PMente Charles · Homestead, FLBuilt 1969 · S/N 24-4856 N93570Huffaker Kenneth Scott · Post, TXBuilt 1973 · S/N 73-32-116

Back to AD 84-19-03 R1