Skip to content

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

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.

N8335CRegistered aircraftBuilt 1982 · S/N 34-8333056 N83364Rhoads Eric S · Costa Mesa, CABuilt 1982 · S/N 28-8390035 N8336GGolden Age N8336g LLC · Norwalk, IABuilt 1981 · S/N 28-8190167 N8336HNeel Aviation LLC · Lakeland, FLBuilt 1981 · S/N 28-8190168 N8338DPlant Galen M · Crown Point, INBuilt 1981 · S/N 28-8116156 N8339DLd Flight LLC · Houston, TXBuilt 1982 · S/N 28-8316030 N833ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496313 N833CFPilotbear Corp · Sherman, CTBuilt 2006 · S/N 2148 N833DSIndiana State University · Terre Haute, INBuilt 2011 · S/N 40.1110 N833EE833ee LLC · Bethany, OKBuilt 2024 · S/N 9951 N833EFLufthansa Aviation Training USA Inc · Goodyear, AZBuilt 2017 · S/N 2378 N833MAberle Jonathan Andrew · Denver, NCBuilt 2005 · S/N 1338 N833NDUnd Aerospace Foundation · Grand Forks, NDS/N 2881292 N833RCTime Machine Adventures LLC · Minot, NDBuilt 2010 · S/N 3689 N833SCBonet Fernando Andres · Miami, FLBuilt 1983 · S/N 34-8333005 N833SD3 Sierra Delta LLC · Orange, CABuilt 2007 · S/N 2327 N833SRN833sr LLC · Mount Sterling, KYBuilt 2005 · S/N 1530 N833TBEuro 2000 Inc · Merritt Island, FLBuilt 2002 · S/N 2842149 N83400Harry Robinson Pontiac Buick DBA · Fort Smith, ARS/N 32R-8129069 N83416Offutt Air Force Base Aero Club · Offutt Afb, NEBuilt 1981 · S/N 28-8116160 N8341ADavidson Air LLC · Hemet, CAS/N 28-8390021 N8341HDbc Aviation LLC · Charlotte, NCBuilt 1981 · S/N 32R-8129047 N8342HBartolf Michael Joseph · Williamston, SCBuilt 1981 · S/N 28-8116162 N8342NHansen Derek J · Lehi, UTBuilt 1981 · S/N 28-8190171 N8342YThompson Kevan R · Penn Yan, NYBuilt 1981 · S/N 28-8190179 N83435Florida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1981 · S/N 34-8133022 N8343HG&C Leasing Inc · Lunenburg, MABuilt 1981 · S/N 32R-8113046 N8343URiley Air LLC · Phoenixville, PAS/N 32R-8329008 N83446Seneca Enterprises LLC · Schwenksville, PAS/N 34-8133025 N8344AAtp Aircraft 8 LLC · Wilmington, DEBuilt 2008 · S/N 4496264 N8344VStandley Joseph · Lake In The Hills, ILBuilt 1982 · S/N 28-8316035 N8345ZTrident Aircraft Inc · Easton, MDBuilt 1981 · S/N 28-8116167 N8346CBroyles Richard M · Wildwood, MOBuilt 1976 · S/N 28-7690120 N8346HAir Jay West LLC · Winnetka, CABuilt 1981 · S/N 28-8190180 N8346NFleetcraft Transportation LLC · Naperville, ILBuilt 1981 · S/N 28-8190181 N8346STravel Express Aviation LLC · West Chicago, ILBuilt 1981 · S/N 28-8190182 N8346TMoradi Mark M · Orlando, FLBuilt 1981 · S/N 28-8190183 N8347CTriple R D2 Jmw Corp · Saint Cloud, MNBuilt 1976 · S/N 28-7690121 N8347WKirk Kevin J · Pulaski, PABuilt 1981 · S/N 32R-8113049 N8348GChelmsford Flyers LLC · Chelmsford, MARegistration ineffective or invalidBuilt 1981 · S/N 32R-8113050 N8348HRogers Gary J · Massapequa, NYBuilt 1981 · S/N 32R-8113051 N834AKGilreath Todd L · Benton, LABuilt 2005 · S/N 1288 N834ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496314 N834CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N 0168 N834DSWimmer Abran A · South Salt Lake, UTBuilt 2001 · S/N 40034 N834EFLufthansa Aviation Training USA Inc · Goodyear, AZBuilt 2017 · S/N 2379 N834HPNewman Aviation Services Inc · Tiffin, OHBuilt 2006 · S/N 3257426 N834HSN873wt Aviation LLC · Lewes, DEBuilt 2025 · S/N 10682 N834KCEcho Papa Aviation LLC · Knoxville, TNBuilt 2007 · S/N 40.834 N834LAHampton Jeffrey · Wayne, ILBuilt 2003 · S/N 0463

Back to AD 2008-06-28 R1