Registered aircraft · 13,519

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:99-05-13-R1-WD') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD') 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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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:99-05-13-R1-WD')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
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.

N1156TAero 1 LLC · Kalispell, MTBuilt 1975 · S/N D-9761 N1157TSalloom Mary M · Gaithersburg, MDBuilt 1975 · S/N E-640 N1159TNxtday Aire LLC · Dover, DEBuilt 1974 · S/N TC-1784 N115AHammerle Edward A · Schuyler Lake, NYBuilt 1939 · S/N 275 N115CA8k Entertainment Inc · Wells, MEBuilt 1981 · S/N D-10371 N115DLJ & S Consulting Solutions LLC · Middletown, DEBuilt 1961 · S/N TD-481 N115MRRussell Keith M · Ivoryton, CTBuilt 1960 · S/N D-6394 N115WDWalton Paul L · Indianapolis, INBuilt 1972 · S/N TE-863 N115WEPhilips Robert Jay · Midlothian, TXBuilt 1976 · S/N TK-15 N1163TIrish Aviation Inc · Orlando, FLBuilt 1975 · S/N TE-1033 N1164WBeaver Brook Aviation LLC · Scotia, NYBuilt 1967 · S/N TE-400 N1165TFlying J Partners Asset Management LLC · Casper, WYBuilt 1975 · S/N D-9754 N1167MN1167m LLC · Saint Peters, MOBuilt 1967 · S/N M-1082 N1168TKnight Oil Resources Inc · New Orleans, LABuilt 1975 · S/N TE-1045 N1169TMorin Daniel P · New Harbor, MEBuilt 1975 · S/N D-9770 N116ABHaller Phillip · Peoria, AZBuilt 1973 · S/N TE-899 N116BDTxbd Investments LLC · Addison, TXBuilt 2002 · S/N E-3454 N116FTaylor John · Mammoth Spring, ARBuilt 1953 · S/N D-3488 N116HRegistration Pending · Kalispell, MTRegistration pendingBuilt 1964 · S/N TC-812 N116LLeavitt Mike · Kamas, UTBuilt 1964 · S/N TC-780 N116TWHatfield David A · West Ossipee, NHBuilt 1973 · S/N D-9529 N1170TJf Capital Series LLC · Truckee, CABuilt 1975 · S/N D-9777 N1174TDynamic Erp Resources Inc · Mansfield, TXBuilt 1975 · S/N TE-1056 N1174VBlack Cat Aviation LLC · Indianapolis, INBuilt 1944 · S/N 6892 N1178TDavis Aviation Group LLC · Gastonia, NCBuilt 1975 · S/N E-794 N1178VSorenson Fred C · Las Vegas, NVBuilt 1944 · S/N 6917 N1179TQuad Rabbit Inc · Wilmington, DEBuilt 1977 · S/N E-1124 N117AGRegistered aircraftN-number assigned, not yet registeredS/N LP-20 N117DMApplied Professional Solutions Llp · Jacksonville, FLBuilt 1968 · S/N MB-381 N117DPMccollum Michael T · Camarillo, CABuilt 1950 · S/N D-2321 N117ECRambana & Ricci Pllc · Tallahassee, FLBuilt 1977 · S/N E-1118 N117FLKinley Air LLC · Wilmington, DEBuilt 1979 · S/N TC-2226 N117JASorbi Aviation Inc · El Cajon, CABuilt 1980 · S/N ME-282 N117KASouthern Latitude LLC · Alabaster, ALBuilt 1972 · S/N TE-852 N117RSJa1 Aviation LLC · Sedan, KSBuilt 1979 · S/N TJ-224 N117WBHicks Jacob · Crozet, VABuilt 1960 · S/N DH-275 N1180VRegistration Pending · Mount Pleasant, TXRegistration pendingS/N 6904 N1181VSchmidt Victor M · Corbett, ORBuilt 1945 · S/N 6706 N1183Sweet Aviation LLC · Dover, DEBuilt 1980 · S/N TE 1183 N1183ABronson Nw Inc · Redmond, ORBuilt 1969 · S/N D-9006 N1184JD&D Chessies LLC · Wilmington, DEBuilt 1980 · S/N E1690 N1184VGrossberg Michael J · Atlantic Beach, FLBuilt 1944 · S/N 6748 N1185VLatta Russell R Trustee · Atwater, CABuilt 1944 · S/N 6746 N118CMEastport Vacation LLC · Wilmington, DEBuilt 1977 · S/N CE-707 N118DJInternational Air Services Inc Trustee · Carson City, NVBuilt 1943 · S/N 43-35634 N118EDSouth America Tactical & Airborne Cousulting Corp · Wilmington, DEBuilt 1974 · S/N TE-1013 N118GBBas Part Sales LLC · Greeley, COS/N MC-582 N118NSagouspe Consulting Services LLC · Hayden, COBuilt 1960 · S/N D-6427 N118NHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1991 · S/N CE-1612 N118SAReid Marici P · Independence, ORS/N BA-14

Back to AD 99-05-13 R1 WD