Registered aircraft · 18,495

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

N818JPN818jp LLC · Los Angeles, CABuilt 1984 · S/N 46-8408047 N818LARegistered aircraftBuilt 1994 · S/N E-2868 N818PDesmet Paul F · Mercersburg, PABuilt 1986 · S/N E-2352 N818PCWindigo Transportation Inc · Waterloo, IABuilt 1982 · S/N P21000803 N818PRMalus Flyers LLC · Henderson, NVBuilt 2001 · S/N E-3397 N818PWFlorez Paving · Sacramento, CABuilt 2012 · S/N TH-2344 N818RMB And D Solutions LLC · Billings, MTBuilt 1978 · S/N TE-1150 N818SDGerges Ebraim · Riverside, CAS/N D-7480 N818TKInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 421C0873 N8190GSchubert Jackie E Jr · Jamestown, TNS/N E-2658 N8191KSummerfields Animal Hospital Pllc · Fort Worth, TXBuilt 1991 · S/N E-2662 N8191RM B Duncan Inc · Bakersfield, CABuilt 1974 · S/N D-9675 N8192ESalerno Michael P · Pueblo, COBuilt 1974 · S/N 18502388 N8192RStarr Aviation LLC · Birmingham, ALBuilt 1974 · S/N E-598 N8195JJani-King Int'L Inc · Addison, TXBuilt 1993 · S/N E-2789 N8195QD&M Enterprise LLC · Wilmington, DEBuilt 1970 · S/N 414-0095 N8196RSchwab Robert · Austin, TXBuilt 1974 · S/N TE-1002 N8198BOrmont Michael L Trustee · Poughkeepsie, NYBuilt 1991 · S/N CE-1637 N8198GSky Wagon LLC · Phoenix, AZS/N U20603778 N8198MGokul LLC · Landrum, SCBuilt 1993 · S/N E-2787 N8198TBuilding Swell LLC · New York, NYBuilt 1993 · S/N CE-1723 N819BRooney William T · Lakin, KSBuilt 1978 · S/N D-10186 N819DKBankston David P · Horseshoe Bay, TXBuilt 1983 · S/N EA-387 N819LAMukherjee Jason S Trustee · Simi Valley, CABuilt 1994 · S/N E-2869 N819LBBowles Jeffrey D · Fitchburg, WIBuilt 1977 · S/N E-1126 N819MTyler David Scott · Mount Pleasant, SCBuilt 2007 · S/N TH-2189 N819MCHagar Corporation · Fort Lauderdale, FLBuilt 1968 · S/N TE-600 N819T3rd Gen Aviation LLC · Lisbon, NDBuilt 1973 · S/N D-9507 N81ADMr Dent Inc · Manheim, PAS/N 401A0023 N81AJAircraft Propulsion Leasing LLC · Holland, OHBuilt 1976 · S/N TK-12 N81BBDunigan Patrick J · Jackson, MIBuilt 1973 · S/N CE-449 N81CLGlassman Aaron · Virginia Beach, VABuilt 1981 · S/N TH-1296 N81DDJdj Transport LLC · Wilmington, DEBuilt 1980 · S/N TH-1212 N81DLLewis Donald C · Winters, CABuilt 1977 · S/N E-1156 N81DRCommonwealth Aviation Service Inc DBA · Richmond, VABuilt 1978 · S/N TH-971 N81DTKbk Aviation LLC · Youngsville, LAS/N 21064519 N81FGBrandis Robert DBA · Taylorville, ILS/N E-2424 N81FMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1999 · S/N 29-0180 N81HBMinard Patricia J · Cheney, KSBuilt 1981 · S/N E-1902 N81HCSmith Ronald Shane · Peachtree City, GABuilt 1990 · S/N TH-1600 N81HWJones Bradley · Farmerville, LABuilt 1981 · S/N 18504141 N81JBWeinstein Berthold W · Livermore, CABuilt 1968 · S/N D-8748 N81KCCraigo Keith A · Addison, TXBuilt 1981 · S/N 21064386 N81LAMiller Arland E · Guaynabo, PRBuilt 1980 · S/N 18504063 N81LPSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N 421C-1083 N81MTBennett Thomas Richard · Brooklyn Park, MNBuilt 1981 · S/N P21000794 N81RJHughes Frank H · Hackberry, LABuilt 1979 · S/N E-1617 N81RYRedding Dermatology Medical Group Inc · Redding, CABuilt 1981 · S/N 340A1238 N81SAGarmin International Inc · Olathe, KSBuilt 2016 · S/N TH-2456 N81SCGl Aircraft Enterprise LLC · Wilmington, DEBuilt 1970 · S/N 21059382

Back to AD 86-13-04 R3