OpenAirDocs.org
AD 2008-06-28 R1

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
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.

N480DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1822N480HPDavenport Benjamin · Elk Grove, CABuilt 2008 · S/N 4692048N480JPWells Vance · Battle Ground, WABuilt 2003 · S/N 40.280N480NDIsland Jet Co · Merritt Island, FLS/N 3449306N480PGYang Chi · Lafayette, COBuilt 2008 · S/N 1887N480RVLizfly LLC · Butler, PABuilt 2000 · S/N 46-36269N480SUSeries D Of Boelte Aviation LLC · Wilmington, DEBuilt 2024 · S/N 9998N4810UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842227N4812JJohnson Chris A · Fort Mohave, AZS/N 28R-30605N481AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843747N481CBTern Royal LLC · Camp Hill, PABuilt 2013 · S/N 4697517N481CDMeyer Eric · Fort Lauderdale, FLBuilt 2005 · S/N 1488N481DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1823N481FDCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10481N481JKCirrus Design Corp · Duluth, MNS/N 11658N481PARegistered aircraftS/N 40.1091N481RABoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2006 · S/N 1643N481ZGalazy Lift II LLC · New York, NYBuilt 1973 · S/N LW-52N4820FS&S Aviation Plus LLC · Greenville, ILBuilt 1976 · S/N 28-7790062N4821FOestreich Klaus M · Needville, TXBuilt 1976 · S/N 28-7790063N482AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843748N482CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1482N482DTCavorite Aviation LLC · Lehi, UTS/N 28-8490071N482MAHappy Landings LLC · Wake Forest, NCBuilt 2005 · S/N 40.552N482STJ & M Holdco LLC · Cookeville, TNBuilt 2008 · S/N 3257482N4830UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842236N4839RGnome Holding Company LLC · Columbus, GABuilt 2007 · S/N 4697293N483AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 9325N483DADevine Aviation LLC · Lewes, DEBuilt 2007 · S/N 1825N483PN483p LLC · Elizabethtown, PABuilt 2007 · S/N 2579N483PGYang Chi · Lafayette, COBuilt 2008 · S/N 1895N4841FVidhun Raghuraman R · Southbury, CTBuilt 1976 · S/N 28-7790067N4846JMiehle Arthur R · Villa Park, ILBuilt 1968 · S/N 28R-30610N484BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881784N484CDNoble Air Leasing LLC · Raleigh, NCBuilt 2020 · S/N 2589N484HPFly With Kay LLC · Fulshear, TXBuilt 1981 · S/N 34-8133199N484JSRyan Kevin · San Antonio, TXBuilt 2022 · S/N 8662N484JWAims Community College · Greeley, COBuilt 2025 · S/N 2881862N484KCN484kc LLC · Salem, ORBuilt 2007 · S/N 2752N484NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881667N4854JTrio Bravo Ltd · Hudson, OHBuilt 1968 · S/N 28R-30611N4857JWogan Ted E · Russellville, ALBuilt 1968 · S/N 28R-30613N4858JSchapiro Stephen Alexander · Lambertville, NJBuilt 1968 · S/N 28R-30614N485AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843749N485AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 9311N485BCInter American University Of Puerto Rico · Bayamon, PRBuilt 2023 · S/N 4496552N485BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881785N485DASale Reported · Crystal, MNSale reportedBuilt 2007 · S/N 1830N485DLBb Co LLC · Parker, COBuilt 2021 · S/N 2694N485DVCluny Aviation LLC · Pinehurst, NCBuilt 2017 · S/N 4473
Back to AD 2008-06-28 R1