Skip to content

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N932FSAviation Equipment Co LLC · Lincoln, NES/N 44-7995018 N932LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496420 N9331PAmra Nabil · Chaska, MNS/N 24-4829 N9332DMartin Clint R · Escondido, CABuilt 1958 · S/N 22-6352 N9333PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 24-4831 N9336DSitta Donald C · Farmington, NMS/N 22-6356 N9337DNantz William G Jr · Raleigh, NCBuilt 1958 · S/N 22-6357 N9337PWesterfield John III · Birmingham, ALBuilt 1969 · S/N 24-4835 N9338PDream Home Aviation Inc · New Smyrna Beach, FLS/N 24-4836 N9339PBreznik John D · Bradford, PABuilt 1969 · S/N 24-4837 N933JMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N 44-8207009 N933LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496421 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 N9349DFoote Jason D · Osakis, MNBuilt 1958 · S/N 22-6371 N934LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496422 N9353PSmith Evan B · Mechanicsville, VABuilt 1969 · S/N 24-4854 N9356PMente Charles · Homestead, FLBuilt 1969 · S/N 24-4856 N9357PNewman Joseph G · Grand Ledge, MIBuilt 1960 · S/N 24-2033 N9358PJeneson Tim · Ketchum, IDBuilt 1969 · S/N 24-4858 N9359PCarter James D · Carlton, TXBuilt 1969 · S/N 24-4859 N935CWIn Flight Aircraft LLC · Howell, MIBuilt 2005 · S/N 4496213 N935ERChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 4496195 N935LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496423 N9364PTougas William E · Timberlake, NCBuilt 1969 · S/N 24-4864 N9369PLoadstone Aviation LLC · Billings, MTBuilt 1969 · S/N 24-4869 N936LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496424 N936RGrandinetti Robert L · Fayetteville, NYBuilt 1967 · S/N 30-1580 N9371PBuschmann Robert O Jr Trustee · Prescott, AZBuilt 1969 · S/N 24-4871 N9372PBeery Milo A · Clarinda, IABuilt 1969 · S/N 24-4872 N9373PLeff Benjamin Franklin · Cedar Park, TXBuilt 1969 · S/N 24-4873 N9379PAerodata Inc · Edgewater, MDBuilt 1969 · S/N 24-4880 N937APerkins Robert R · Walnutport, PABuilt 1951 · S/N 22-241 N937LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496425 N9380PEchelmeier Stanton M · Fort Payne, ALBuilt 1969 · S/N 24-4881 N9381PSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 24-4882 N9382PRegistered aircraftBuilt 1969 · S/N 24-4883 N9384PDarling Rob K Dds · Venice, FLBuilt 1969 · S/N 24-4885 N9386PWilson Jay · Omro, WIBuilt 1969 · S/N 24-4887 N938AJason Rozas · Eunice, LABuilt 1951 · S/N 22-243 N938LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496426 N9390PFlaherty Stephen · El Paso, TXBuilt 1969 · S/N 24-4891 N9391PRusty Ventures LLC · Watertown, SDS/N 24-4893 N9393PBoucher Bobbi · Fredericksburg, VABuilt 1969 · S/N 24-4895 N9394PS A Freight International Inc · San Antonio, TXBuilt 1969 · S/N 24-4897 N9395PPlane Fun Inc Tr Trustee · Snellville, GABuilt 1969 · S/N 24-4898 N9396PTrom Michael S · Lake Ozark, MOBuilt 1969 · S/N 24-4899 N9397PStarritt Mark C · Hollister, CABuilt 1969 · S/N 24-4901

Back to AD 85-02-05 R1