Registered aircraft · 16,284

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-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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.

N901TMMatanane Roke C · Barrigada, GUBuilt 1977 · S/N LW-227 N9029RArx Aviation LLC · Eustis, FLBuilt 1975 · S/N LW-132 N902DSMount Daufuskie Charters Inc · Greenwich, CTBuilt 2008 · S/N 40.982 N902ESDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 2002 · S/N 1253 N902FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842174 N902MBB & M Aviation LLC · Bonneau, SCBuilt 1974 · S/N LW-105 N902MRJoerithan & Mp Aviation LLC · Whittier, CAS/N 40.324 N902PADefranco Peter Jr · Hueytown, ALBuilt 2002 · S/N 2843530 N902SESoutheastern Oklahoma State University · Durant, OKBuilt 2020 · S/N 2602 N902SRPlane Fun Inc Tr Trustee · Snellville, GABuilt 2007 · S/N 2356 N902TVRamjet 990 LLC · Ashburn, VABuilt 2020 · S/N 2542 N9036KGriffiths Gregory S · Johnson City, NYBuilt 1977 · S/N 28-7816184 N9038KNorthwest Aviation LLC · Gig Harbor, WABuilt 1977 · S/N 28-7816185 N903EESkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843229 N903FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842175 N903PSWesley Emerson Holdings LLC · Clifton, TXBuilt 2021 · S/N 2662 N903RDJkj Aviation LLC · Wilmington, NCBuilt 2018 · S/N 4709 N903RMSmith Jordan · Athens, ALBuilt 2004 · S/N 0903 N903TRCirrus Design Corp · Hermantown, MNBuilt 2023 · S/N 9091 N9040KGidden Aviation LLC · Katy, TXBuilt 1977 · S/N 28-7816186 N9044FFiggins Matthew J · Stewardson, ILBuilt 1976 · S/N 28-7790277 N9045KHounslow Michael L · Rockville, MDBuilt 1977 · S/N 28-7890173 N904AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881944 N904AZWingsleasing LLC · Wichita, KSBuilt 2008 · S/N 40.920 N904BLAls Aviation LLC · Jacksonville, FLBuilt 2019 · S/N 4757 N904CDTrailer Trash Management LLC · Coburg, ORBuilt 2006 · S/N 2306 N904HBohanon Air LLC · Jonesboro, ARBuilt 1979 · S/N LW-239 N904LMLls LLC · Fort Wayne, INS/N 3904 N904STAir Alpes Services Corp · Wilmington, DEBuilt 2005 · S/N 1473 N905AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881945 N905AMSkyline Aviation Inc · San Angelo, TXBuilt 2006 · S/N 40.705 N905CAVolair Aviation LLC · Waxhaw, NCBuilt 2007 · S/N 40.795 N905CMMaas Holdings LLC · Fort Wayne, INBuilt 2008 · S/N 4692094 N905DSHouser Theodocia Z · San Angelo, TXBuilt 2001 · S/N 3257236 N905EMLakeshore Aviation LLC · Denver, NCBuilt 2018 · S/N 4636728 N905NDDodson International Parts Inc · Rantoul, KSS/N BB-468 N905NYAzul Air LLC · Dover, DEBuilt 1972 · S/N LW-6 N905PARamsey Scott A · Houston, TXBuilt 2008 · S/N 40.905 N905PCLamb Robert Duncan · Kiln, MSBuilt 2003 · S/N 42026 N905SECc Self Aircraft Holding LLC · Wilmington, DEBuilt 2006 · S/N 2090 N9062KMiloud Chadd K · Fort Worth, TXBuilt 1977 · S/N 28-7816187 N906CDHiggins Mechanical Inc · Gardner, MABuilt 2003 · S/N 0523 N906GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881471 N906MBWdm Seneca LLC · Augusta, GABuilt 2013 · S/N 3449472 N906PATeton Avjet LLC · Driggs, IDBuilt 2008 · S/N 40.906 N906RDCollareno Kevin A · Northville, MIBuilt 2005 · S/N 1264 N9077KPacific Coast Aero Inc · Torrance, CABuilt 1977 · S/N 28-7816188 N907CAllen Gavin Alton · Bloomfield, CTBuilt 2002 · S/N 0385 N907CDGullapalli Vamsi K · Sartell, MNBuilt 2005 · S/N 1706 N907DRWhite Warren R · Birmingham, ALBuilt 2005 · S/N 1300

Back to AD 2008-06-28 R1