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.

N60PMCeahorse LLC · Greenwich, CTBuilt 2019 · S/N 4636744N60RADodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N BT-7N60UHSecret Destinations LLC · Gretna, LABuilt 2011 · S/N 3784N60WUWsu Campus Of Applied Sciences And Technology · Wichita, KSBuilt 2025 · S/N 4496615N6101GPack Aviation LLC · San Jose, CABuilt 2008 · S/N 4697340N6103GFnf Investments LLC · Texarkana, ARBuilt 2010 · S/N 4692147N6103YQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 0634N6105DLankenau John · Lake Havasu City, AZBuilt 2010 · S/N 4697426N6105EBas Part Sales LLC · Greeley, COS/N 4692150N6105XKramer James W Jr · Eynon, PABuilt 2003 · S/N 0618N6106CB & S Aviation Enterprises LLC · Atlantic Beach, FLBuilt 2003 · S/N 0601N6107QKk Equipment Leasing LLC · Seguin, TXBuilt 2003 · S/N 0633N6108XCoosa Air LLC · Wilmington, DEBuilt 2008 · S/N 4692036N610BCLoki Operations LLC · San Jose, CABuilt 2006 · S/N 41683N610BZCirrus Design Corp · Duluth, MNS/N 11692N610CDChalin Flight Services LLC · Wilmington, DEBuilt 2019 · S/N 4759N610ECPeloton Aviation LLC · Wentzville, MOBuilt 2023 · S/N 4636834N610FAStratus Rr LLC · New Castle, DEBuilt 2023 · S/N 28020110N610NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881136N610SCFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 2881600N610UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020166N6112JColeman Timothy Lynn · Port Charlotte, FLBuilt 1976 · S/N 28-7690342N6113JOracle Aviation LLC · Omaha, NEBuilt 1976 · S/N 28-7690343N611AKConverse Richard L Jr · Durango, COBuilt 2003 · S/N 4697163N611CDPj Aviation LLC · Lake Worth, FLBuilt 2005 · S/N 1599N611CTBrown Jed A · Laredo, TXBuilt 2008 · S/N 2911N611DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1848N611ESGs Flying Club LLC · Bethlehem, PABuilt 2008 · S/N 3053N611FTCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841223N611JPAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1978 · S/N 287916111N611KCBerks-Fire-Water-Restorations Inc · Reading, PABuilt 2011 · S/N 4692166N611KGProckter Aviation LLC · Lagrangeville, NYBuilt 2005 · S/N 1551N611MHAwesome Aero LLC · South Plainfield, NJBuilt 2004 · S/N 40.408N611RJRj 400 LLC · Iowa City, IAS/N 41044N611RMRm Management Corp · Johnson City, TNBuilt 2004 · S/N 1133N611RTGrutza Robert J · Maysville, KYBuilt 2007 · S/N 2523N611SCFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 2881601N611VAAc Aviation LLC · Columbus, OHBuilt 2021 · S/N 2690N611VRRex Vinod · Sunnyvale, CABuilt 2004 · S/N 0924N611WBDelicious Epiphany LLC · Fort Wayne, INBuilt 2022 · S/N 9006N611WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 9778N6121HRethink Creative Group LLC · Fort Worth, TXBuilt 1977 · S/N 28-7816225N6123JBullard Dennis E · Fort Myers, FLBuilt 1976 · S/N 28-7690345N6123QAirflair Inc · Maurice, IABuilt 1976 · S/N 28-7790065N6124JCrews Aaron Gregory · Boone, IABuilt 1976 · S/N 28-7690346N6124MDiscovery Air LLC · Austin, TXBuilt 2000 · S/N 3257143N6127HBless Howard P · Pennsburg, PAFirst renewal noticeBuilt 1977 · S/N 28-7816226N6129HHouk Air LLC · Waverly, OHBuilt 1977 · S/N 28-7890209N612CDPanoramic Aviation LLC · Fort Collins, COS/N 1591N612CTGl One LLC · Ankeny, IABuilt 2008 · S/N 3062
Back to AD 2008-06-28 R1