Skip to content

Registered aircraft · 47,138

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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') 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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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:2000-23-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
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.

N340DFWyatt Barbara · Cheyenne, WYBuilt 1973 · S/N 340-0229 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 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 N340HESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 340A1503 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 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 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 N340KYE Lite Aviation Inc · Cordova, TNFirst renewal noticeBuilt 1978 · S/N 340A0622 N340L310 Air Ltd · Seville, OHBuilt 1978 · S/N 340A0518 N340LBSteed Dan E Trustee · Groom, TXBuilt 1972 · S/N 340-0053 N340LCChase 13 LLC · Wilmington, DEBuilt 1966 · S/N CE-53

Back to AD 2000-23-21