Skip to content

Registered aircraft · 3,961

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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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.

N340DJCistriacus Aircraft Corp Trustee · Wilmington, DEBuilt 1979 · S/N 340A0722 N340DMMaxxum Financial Group Inc · Destrehan, LABuilt 1978 · S/N 340A0462 N340DSBig Sky Investment Properties LLC · Corvallis, MTS/N 340A0930 N340DTRegistration Pending · Jennings, LARegistration pendingBuilt 1976 · S/N 340A0054 N340DVFly Fast Live Slow LLC · Dandridge, TNBuilt 1981 · S/N 340A1220 N340DWSilver David Scott · Brookings, ORBuilt 1978 · S/N 340A-0497 N340EBBrunn Michael D Trustee · Modesto, CABuilt 1976 · S/N 340A0090 N340EEFoley Mark R · Northwood, NHBuilt 1981 · S/N 340A1225 N340ELBaas Brian J · Cambridge, MNBuilt 1980 · S/N 340A1004 N340EMBiotech Aviation LLC · Rio Rancho, NMBuilt 1982 · S/N 340A1516 N340EPSouth Bay Aviation LLC · Virginia Beach, VABuilt 1980 · S/N 340A1013 N340ERSanchez Rogelio · San Diego, CABuilt 1982 · S/N 340A1529 N340ESPlane Convenient LLC · Canton, OHBuilt 1978 · S/N 340A0505 N340EZRidley Benjamin · Jamesville, NYBuilt 1976 · S/N 340A0118 N340FCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1976 · S/N 340A0044 N340FAIn Flight Dynamics LLC · Kirtland, OHS/N 340A0527 N340FFMiller Brothers Aviation LLC · Lebanon, PABuilt 1978 · S/N 340A0495 N340FJBurris D Rob Trustee · Tucson, AZBuilt 1976 · S/N 340A0060 N340FKMichelesaire Inc · Wilmington, DEBuilt 1980 · S/N 340A1007 N340FMVogel Mark E · Orange City, IABuilt 1980 · S/N 340A1032 N340FPSeabury John L · Erie, COS/N 340A0298 N340FRS&S Sky LLC · Thatcher, AZBuilt 1976 · S/N 340A0039 N340GDurango Air LLC · Portland, ORBuilt 1980 · S/N 340A1006 N340GBMbw Aviation LLC · Bay City, MIS/N 340A0618 N340GCShupe David L · Dayton, NVS/N 340A-0369 N340GGMarlowe Clifford Gray · Maxwelton, WVBuilt 1979 · S/N 340A0916 N340GKRiv Desert Sun LLC · Phoenix, AZBuilt 1979 · S/N 340A0625 N340GMElbitamerica Inc · Merrimack, NHBuilt 1976 · S/N 340A0202 N340GSRelevance Capital Management LLC · Brentwood, TNBuilt 1972 · S/N 340-0183 N340GTWow-We Wings LLC · Pawleys Island, SCBuilt 1981 · S/N 340A1249 N340GWThree Rivers Limousine Service Inc · Pittsburgh, PABuilt 1979 · S/N 340A0706 N340HCPropjet 210 Aviation Inc · Windsor, CAS/N 340A0638 N340HESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 340A1503 N340HGVan Haitsma Kelly · Fort Worth, TXBuilt 1973 · S/N 340-0228 N340HWHartung Stefan · Greenville, SCBuilt 1976 · S/N 340A0265 N340JOkla-Tex Energy Corp · Tyler, TXS/N 340-0171 N340JCS O W Aviation LLC · Crystal River, FLBuilt 1979 · S/N 340A0801 N340JDWescott Aviation LLC · Prospect, KYBuilt 1972 · S/N 340-0100 N340JFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 340A0451 N340JJAmnr LLC · Shawnee, OKS/N 340-0040 N340JLLechman Joseph · Agoura Hills, CABuilt 1982 · S/N 340A1543 N340JMHunter Pilot Services LLC · Hollister, CABuilt 1978 · S/N 340A0640 N340JPOlive Aviation LLC · Anchorage, AKBuilt 1973 · S/N 3400232 N340JQLiu Qi · Saratoga, CAS/N 340A0279 N340JSAsher Kenneth Edward · Durango, COBuilt 1979 · S/N 340A0661 N340KRegistered aircraftBuilt 1979 · S/N 340A0792 N340KCRegistered aircraftBuilt 1980 · S/N 340A0959 N340KGAero Vulcan LLC · Moody, ALBuilt 1982 · S/N 340A1505 N340KSDavieation III LLC · St Simons Is, GABuilt 1981 · S/N 340A1501 N340KTN44fu LLC · Oklahoma City, OKBuilt 1977 · S/N 340A0356

Back to AD 87-21-02 R1