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.

N745ARLlv Aviation LLC · Naples, FLBuilt 2006 · S/N 2131N745CDTrujillo Dax K · Show Low, AZS/N 0040N745DSSkywest Leasing Inc · Saint George, UTBuilt 2007 · S/N 40.745N745MAStrategic Health Inc · Sandy, UTS/N 3449245N745NBT & H Ahrens LLC · Nevada City, CABuilt 2006 · S/N 1891N745NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843860N745PASkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881017N745RAAri Ben Aviator Inc · Fort Pierce, FLBuilt 1990 · S/N 2841327N7462JFirmino Paulo · Gainesville, TXBuilt 1968 · S/N 28R-30814N7463JUnusual Attitudes LLC · Bates City, MOS/N 28R-30815N7467JDouble Bridges Aviation · Enterprise, ALBuilt 1968 · S/N 28R-30819N7469JSussex Aero Maintenance Inc · Georgetown, DEBuilt 1968 · S/N 28R-30822N746AAtp Aircraft 6 LLC · Wilmington, DEBuilt 2007 · S/N 4496243N746ABCitation Point Leasing LLC · Naples, FLS/N 4737N746CBr Aviation LLC · Bellevue, WABuilt 2002 · S/N 0413N746CDSky West Aviation Inc Trustee · Albuquerque, NMS/N 0074N746DSCp LLC · Ooltewah, TNS/N 40.746N746GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881461N746JAInternational Air Services Inc Trustee · Carson City, NVBuilt 2016 · S/N 4375N746KFTriple Fes LLC · San Antonio, TXBuilt 1979 · S/N BB-473N746NDUniversity Of North Dakota · Grand Forks, NDBuilt 2021 · S/N 2881489N746PASkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881018N746SRGossett John · Bellbrook, OHBuilt 2006 · S/N 2235N746TMFlyt Club LLC · Commerce Township, MIBuilt 2006 · S/N 1654N7470JPrairie View Energy LLC · Granite Falls, MNBuilt 1968 · S/N 28R-30823N7474JHorton James D · Las Vegas, NVS/N 28R-30827N7476JHernandez Miguel A · Brownsville, TXBuilt 1968 · S/N 28R-30831N7478Hubbard Matthew L · Phoenix, AZBuilt 2002 · S/N 0420N7478JGallo Gerald F · Worcester, MABuilt 1968 · S/N 28R-30834N7479JHouse Nancy L · Sherwood, ARBuilt 1968 · S/N 28R-30835N747ASRooks Peter L · Andover, MABuilt 2022 · S/N 8998N747AUAuburn University · Auburn, ALBuilt 2019 · S/N 4496455N747AYYoder Construction Inc · Treynor, IABuilt 2002 · S/N 1257N747CDMbs Aviation LLC · Terre Haute, INBuilt 2023 · S/N 9213N747CTN747ct LLC · Mayfield, KYBuilt 2017 · S/N 4485N747CVGeorge Walker Field Inc · Bedminster, NJBuilt 1999 · S/N 2843245N747CWDynamic Engineering Inc · Van Buren, ARBuilt 2005 · S/N 41509N747DSDelaware State University · Dover, DEBuilt 2019 · S/N 4496486N747EEischen-1b LLC · Fairview, OKBuilt 2008 · S/N 1996N747FCEastern Stearman Inc Trustee · Leesburg, VABuilt 2008 · S/N 1987N747GVPlane Sol LLC · Laredo, TXBuilt 2022 · S/N 2881586N747JSAlameda Aero Club · Alameda, CABuilt 1967 · S/N 28R-30365N747LJEichleay Peter · Yarmouth, MES/N 0535N747LLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 0496N747MBMaitland Egerton M Jr Dr · Lexington, SCBuilt 2008 · S/N 2913N747PJOsprey Capital LLC · Winston Salem, NCBuilt 2005 · S/N 1483N747PLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 2289N747SDAvitrans Inc · Cypress, CABuilt 2006 · S/N 2245N747SJBuell Steven M · Fisherville, KYBuilt 2001 · S/N 0091N747SLWesley Kelley · Pontotoc, MSBuilt 2006 · S/N 42550
Back to AD 2008-06-28 R1