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.

N627PABig Sky Leasing LLC · Johnson, KSBuilt 2014 · S/N 4636627N627PWSattofas Air LLC · Gilbert, AZBuilt 2007 · S/N 2793N627RGSummer Flight LLC · Selbyville, DEBuilt 2004 · S/N 1243N627SBFeucht Chad · Fond Du Lac, WIBuilt 2007 · S/N 2194N627SRAccurate Corp · Wilmington, DEBuilt 2006 · S/N 2047N627VAV1 Venture Aviation Lp · Olathe, KSBuilt 2025 · S/N 10563N627ZZWwfly LLC · San Luis Obispo, CABuilt 2007 · S/N 2479N6281CMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 28-7816403N6287JAdil Junaid · Tucson, AZBuilt 1976 · S/N 28-7690392N6288JIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7690393N628BBAmerican Lumber And Plywood Inc · Guntersville, ALBuilt 2005 · S/N 42073N628CSWiggins Glenn C · Kewadin, MIS/N 0738N628ECTech Aviation Inc · Daytona Beach, FLBuilt 2010 · S/N 3601N628FTFlorida Institute Of Technology · Melbourne, FLBuilt 2001 · S/N 2842124N628MSansa May Aviation LLC · Eaton Rapids, MIBuilt 2006 · S/N 1682N628RMThree Three Whiskey LLC · Kennett, MOBuilt 2013 · S/N 3921N6293JClear Horizon Holdings LLC · Cheyenne, WYBuilt 1976 · S/N 28-7690395N6294CB A R C Asset Management LLC · Boynton Beach, FLBuilt 1978 · S/N 28-7890358N6297JYale Aviation Inc · New Haven, CTBuilt 1976 · S/N 28-7690394N629AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2025 · S/N 10891N629CDrc Aviation Of Stuart LLC · Palm City, FLBuilt 2003 · S/N 3257331N629DKUnited Steel Erectors Corp · Atlantic, IABuilt 1998 · S/N 4636158N629DMLdm Logistics LLC · Orrville, OHBuilt 2008 · S/N 3092N629FTFlorida Institute Of Technology · Melbourne, FLBuilt 2001 · S/N 2842132N629LFJamestown Aviation LLC · Neenah, WIBuilt 2006 · S/N 2189N629MAMac Air LLC · Charlotte, NCBuilt 2025 · S/N 10524N629NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881148N629NFSunstarr Aviation LLC · Fond Du Lac, WIS/N 28-7790431N629STHolokai LLC · Boyes Hot Springs, CABuilt 2014 · S/N 4636629N62CASchoenle Paul D · South Bend, INBuilt 1996 · S/N 4636025N62CHSecond Chance Wings LLC · Leander, TXBuilt 2006 · S/N 2180N62GWGoshen Wings Inc · Bristol, INBuilt 1980 · S/N 32R-8129030N62KDRegistered aircraftRegistration pendingS/N 0767N62LNDeeds Little Corp · Wilmington, DEBuilt 2012 · S/N 4636533N62LTLima Tango LLC · Mariposa, CABuilt 2001 · S/N 4697027N62MDRegistration Pending · Deland, FLRegistration pendingBuilt 1969 · S/N 28R-31073N62VBHickory Lane Corp · Farmingdale, NYBuilt 2023 · S/N 9166N62VURfto LLC · Carthage, ILBuilt 2025 · S/N 10817N62VXDunham Darin T · Meridianville, ALBuilt 2001 · S/N 0090N62WRLamay-O Inc · Shreveport, LAFirst renewal noticeBuilt 2006 · S/N 1606N6300BLimit Up LLC · New York, NYBuilt 2001 · S/N 1157N6301CMustang Aviation LLC · Orleans, NEBuilt 1978 · S/N 28-7890359N630AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2025 · S/N 10906N630CDDanoair LLC · Easton, MDS/N 0962N630ESJez Farms LLC · Mattoon, ILBuilt 2019 · S/N 4636740N630HCDgsz Aero Inc · Bear, DEBuilt 1980 · S/N 28-8090268N630KBKilo Bravo LLC · Saratoga, CABuilt 2014 · S/N 4636625N630KTLetourneau Duane R · Oconto, WIBuilt 2000 · S/N 28-43397N630MDDeh Inc · Topeka, KSBuilt 2005 · S/N 1269N630RAAb & D Custom Furniture Inc · Monee, ILBuilt 2007 · S/N 2872
Back to AD 2008-06-28 R1