Registered aircraft · 34,767

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

N1001A1st Avenue Ttc LLC · Los Angeles, CAS/N CG3 N1001VLawson Justin Chadwick · Watkinsville, GABuilt 1976 · S/N R1722074 N1002GFlying Fox Aviation LLC · Idaho Falls, IDBuilt 2000 · S/N 27-0295 N10033Thunderfighter LLC · Englewood, COS/N 172S9797 N1003JTownsley Doyle · Saucier, MSBuilt 1972 · S/N 10 N1004DGiezen Jurgen J · Fairfax, VAS/N 26001C N1004EUnison Air LLC · Palo Alto, CABuilt 2005 · S/N 172S9872 N1004JTroxell Timothy W · Roy, WABuilt 1972 · S/N 16 N1004NStokes David A · Burton, MIBuilt 1972 · S/N 167 N1004TI1 Aviation LLC · Ronkonkoma, NYBuilt 2010 · S/N 13012 N1004VSalt Aerial Aviation LLC · Hamel, MNBuilt 1976 · S/N R1722075 N1005ESemaska Victor J · Kensington, CTBuilt 1977 · S/N 299-77 N1005UHapka Michael · Winchester, INBuilt 1989 · S/N 25-1210 N1005XSigler Lanny · Albuquerque, NMBuilt 2000 · S/N 27-0302 N1006UFike Brian Arthur · Florissant, COBuilt 1993 · S/N 24-3291 N1006VLanier Equipment Leasing LLC · Gainesville, GABuilt 2005 · S/N 172S9805 N1007RUts Aviation LLC · Gainesville, VAS/N 25-0052 N1007VSmith Loren Dallas · Great Falls, MTS/N 73-31060 N1007XD&R LLC · Emory, TXS/N 34-7570182 N1008CBat Flying LLC · Blue Earth, MNBuilt 1981 · S/N 24-1100 N1009EAven Michael D · Georgetown, INBuilt 1977 · S/N 606-77 N100AESale Reported · Spencer, NESale reported, pending cancellationBuilt 1978 · S/N 32R-7985058 N100BJAllen David L · Eastpoint, FLBuilt 1966 · S/N 32-40077 N100BSC & C Logging LLC · Kelso, WABuilt 1966 · S/N 27-3431 N100CNAileron Aviation Inc · Sparta, TNS/N 27-7754050 N100CPCivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N T20609818 N100DDCook Allen J · Aurora, COBuilt 1948 · S/N NAV41518 N100EEConcho Aviation LLC · Sterling City, TXBuilt 2006 · S/N 11028 N100ELLeading Edge Leasing LLC · Wilmington, DES/N 310Q-0688 N100EMKentem100 LLC · Asheboro, NCBuilt 1981 · S/N 31-8152196 N100ENRegistration Pending · Downingtown, PARegistration pending, pending cancellationS/N 816 N100EUSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2021 · S/N 28020030 N100GDElp LLC · Bedford, NHBuilt 2024 · S/N T18209152 N100GLWaco Aircraft Corp · Battle Creek, MIBuilt 2021 · S/N 1215 N100GSPegasus Florida I Inc · San Diego, CABuilt 1974 · S/N P-301 N100HWYale Companies LLC · Fishers, INBuilt 2025 · S/N 2881884 N100HX14 Aero Spaces LLC · Wilmington, DEBuilt 2008 · S/N 18282087 N100JGClub Cherokee Inc · Crystal, MNBuilt 1988 · S/N 3213019 N100JRLumland Properties LLC · Winchester, VABuilt 1969 · S/N 31-599 N100JVKremers Gary · Zeeland, MIBuilt 2012 · S/N 40992 N100KAConservation Flight LLC · Bronx, NYBuilt 2006 · S/N T20608602 N100KYRegistration Pending · Weston, FLRegistration pendingBuilt 1987 · S/N 901 N100LED&J Training Planes LLC · Logan, UTBuilt 2023 · S/N 172S13000 N100LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2025 · S/N 172S13292 N100LULynn University Inc · Boca Raton, FLBuilt 1997 · S/N 17280075 N100LWN100lw LLC · Hickory, NCBuilt 1980 · S/N 32-8006091 N100MPMeyer Christopher R · Colchester, CTBuilt 1976 · S/N 1-0038 N100NESanborn Map Co Inc · Colorado Springs, COS/N 31-7712022 N100NYAplustill Keith A · Los Osos, CABuilt 1985 · S/N 24-1526 N100POut Island Magic LLC · Gainesville, FLBuilt 1982 · S/N 31-8252019

Back to AD 2008-08-14