Skip to content

AD 2008-06-28 R1

Registered aircraft · 16,284

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.

N930SEStevens Neil Larry · Bingham Lake, MNBuilt 2006 · S/N 2254 N930SLK2 Aviation LLC · Greenwood Village, COBuilt 2019 · S/N 2517 N930SSV1 Aviation Leasing LLC · Fairborn, OHS/N 32R-8113061 N930ZMirage 930 Corp Trustee · Wilmington, DEBuilt 1995 · S/N 4622188 N9313CWright Terrence Richard · Tiffin, OHBuilt 1978 · S/N 28-7816459 N9313KStauffer Donald R Jr · Tracy, CABuilt 1976 · S/N 28-7690241 N9318CTarakji Mohamad Hani A · Van Nuys, CABuilt 1978 · S/N 28-7890398 N931CDAsteria Technologies Inc · Manassas, VAS/N 0261 N931CTCub Aviation LLC · Wilmington, DEBuilt 2008 · S/N 2931 N931ECRegistration Pending · Panama City, FLRegistration pendingBuilt 2021 · S/N 2881511 N931GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881076 N931LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496419 N931TTCompass Pro LLC · Baldwin, WIBuilt 2008 · S/N 4636441 N9324KBellew Philip H · Gadsden, ALBuilt 1976 · S/N 28-7690243 N932ACHodge&Langley Law Firm Pc · Spartanburg, SCBuilt 2008 · S/N 411021 N932CDTeam Aviation II LLC · Wilmington, DEBuilt 2002 · S/N 1231 N932DRSmile Tx Holdings LLC · Horseshoe Bay, TXBuilt 2017 · S/N 2356 N932ECRegistration Pending · Panama City, FLRegistration pendingBuilt 2021 · S/N 2881512 N932FSAviation Equipment Co LLC · Lincoln, NES/N 44-7995018 N932GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881077 N932LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496420 N932TARadioactive LLC · Ft Wright, KYS/N 1537 N9334CBadzinski James P · Roseville, MNBuilt 1978 · S/N 28-7816461 N9337CLovett Zachary · Fort Worth, TXBuilt 1978 · S/N 28-7816462 N9338CSmart4 LLC · Kissimmee, FLBuilt 1978 · S/N 28-7816463 N933CC27 Latitude LLC DBA · West Palm Beach, FLBuilt 1979 · S/N 28-7990503 N933CDCook Larry · Midland, TXBuilt 2004 · S/N 1233 N933DHBonanza Associates Llp · Colorado Springs, COBuilt 2003 · S/N 0772 N933DSDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2003 · S/N 40.327 N933GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881224 N933JB3jb LLC · Nashville, TNBuilt 2019 · S/N 2494 N933LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496421 N933SCAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881873 N933WPMed Shuttle LLC · Jackson, TNBuilt 2016 · S/N 4370 N9341CMerlin Aviation LLC · South Saint Paul, MNBuilt 1978 · S/N 28-7890399 N934LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496422 N934NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881887 N9358CMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 28-7816466 N935AZN935az LLC · Miami, FLBuilt 2003 · S/N 40.320 N935CDRussell Ronald W · Auburn, ALBuilt 2003 · S/N 0454 N935CWIn Flight Aircraft LLC · Howell, MIBuilt 2005 · S/N 4496213 N935DELong Island Aviators LLC · Seaford, NYBuilt 1978 · S/N 28-7990146 N935ERChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 4496195 N935GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881078 N935LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496423 N935SRSmaistrla Jeffrey L · Montgomery, TXBuilt 2007 · S/N 2482 N935TSLvta Holdings LLC · Dundee, OHBuilt 2009 · S/N 3446 N9360CPure Joy Aviation One LLC · Schaumburg, ILBuilt 1978 · S/N 28-7890401 N936CMContinental Aerospace Technologies Inc · Mobile, ALBuilt 2007 · S/N 2447 N936KCLive Right Travel LLC · Pagosa Springs, COBuilt 2001 · S/N 0068

Back to AD 2008-06-28 R1