Registered aircraft · 16,280

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.

N705CCPappa Mike Holdings LLC · Rayville, LABuilt 2016 · S/N 4350 N705CDLearjetjohn Flying Club LLC · Moulton, ALS/N 0005 N705CFStanbridge Dale · Phoenix, AZBuilt 1979 · S/N 28-7916339 N705DMHysmith Nicholas Daniel · Germantown, TNBuilt 2001 · S/N 1150 N705MAJ K Air LLC · Columbus, INBuilt 2006 · S/N 4697277 N705MMLeon Marco M · Broadlands, VABuilt 1978 · S/N 28-7816648 N705NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881022 N705SAVisser Stephen Barney · Lakewood, COBuilt 2007 · S/N 2668 N706CGDonegal Excavating Inc · Lemont, ILBuilt 2016 · S/N 4636706 N706DSRoadside Aviation LLC · Silver Spring, MDBuilt 2007 · S/N 40.858 N706NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881023 N706PMGizmo Aviation LLC · Roswell, NMS/N 4697210 N706RAChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843899 N706RHDc Aviation LLC · Venice, FLBuilt 2006 · S/N 1690 N706ZHlm706z Inc · Bismarck, NDBuilt 2000 · S/N 4636256 N707ASCook Todd · South Solon, OHBuilt 2003 · S/N 40.315 N707AUPiper Aircraft Inc · Vero Beach, FLS/N 4496654 N707AZColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2022 · S/N 8614 N707GGLiberty Flight LLC · Goshen, NYBuilt 2006 · S/N 2251 N707GZSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2013 · S/N 4636577 N707MABlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 4496571 N707PSSummit Aviation Inc · Belgrade, MTBuilt 2005 · S/N 40.557 N707SWNep Air LLC · Vineland, NJBuilt 2025 · S/N 10889 N707TDWhite Plains Enterprise LLC · Kalispell, MTBuilt 2005 · S/N 1363 N707THFly Boys LLC · Lincoln, NEBuilt 2003 · S/N 0707 N707TLCentral Virginia Aviation Inc · North Dinwiddie, VAS/N LW-173 N707WTFifth Chance Media LLC · Jupiter, FLBuilt 2005 · S/N 1522 N708ATAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 1909 N708AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2026 · S/N 4496636 N708CPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 3076 N708CTWilliam Polk Medical LLC · Nashville, TNBuilt 2009 · S/N 3466 N708ESWisconsin Aviation Inc · Watertown, WIBuilt 2006 · S/N 1856 N708JAYale Companies LLC · Fishers, INBuilt 2026 · S/N 28020263 N708LAN708la LLC · Philadelphia, PABuilt 2025 · S/N 28020220 N708RWBanks Wes J · Oakdale, CABuilt 2003 · S/N 0514 N708TFAverett University · Danville, VABuilt 2019 · S/N 2881238 N7098CVan Bortel Aircraft Inc · Arlington, TXBuilt 2006 · S/N 41631 N709ARIantosca Real Estate Inc · Jamaica Plain, MABuilt 2021 · S/N 5026 N709BTAverett University · Danville, VABuilt 2017 · S/N 2843920 N709CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881729 N709CCTransport Partners LLC · Huntersville, NCBuilt 2008 · S/N 4692030 N709CDTurton Enterprises Co · Wilmington, DEBuilt 2001 · S/N 0029 N709DFGregoire Aviation Services LLC · New York, NYBuilt 1979 · S/N 28-7916349 N709FAFlyward LLC · Cockeysville, MDBuilt 2010 · S/N 3643 N709GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881205 N709KMTuffy LLC · Jacksonville, ORBuilt 2009 · S/N 3456 N709LAN709la LLC · Philadelphia, PABuilt 2025 · S/N 28020221 N709NCAscension Aviation LLC · Gaylord, MIBuilt 1978 · S/N LW-276 N709SCRunamuck LLC · New Orleans, LABuilt 2023 · S/N 2881624 N709WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 9915

Back to AD 2008-06-28 R1