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.

N68PFWooden Steve S Trustee · Nokomis, FLBuilt 2013 · S/N 4021 N68SYFreeman William M · Cameron Park, CABuilt 2004 · S/N 0930 N68VUVincennes University · Vincennes, INBuilt 2025 · S/N 11041 N68ZBHickory Lane Corp · Farmingdale, NYBuilt 2025 · S/N 10477 N6903JGreen Valley Aerospace LLC · Lexington, VABuilt 1976 · S/N 28-7690425 N6904JGlass Michael C · Maysville, KYBuilt 1976 · S/N 28-7690426 N6905ZZellers And Smith Enterprises LLC · Flowood, MSBuilt 1968 · S/N 28R30649 N6908BMeriden Aviation Center LLC · Meriden, CTBuilt 1985 · S/N 28-8516050 N6909ADupont Alexander Rene · East Taunton, MAS/N 28-8516053 N6909TAlpha-One Air Service LLC · Concord, NCS/N 28-8516049 N690CDBone Voyage Aviation LLC · North Miami Beach, FLBuilt 2005 · S/N 1595 N690GLathem Russell Glen · Dalhart, TXBuilt 1972 · S/N LW-34 N690HAAims Community College · Greeley, COBuilt 2025 · S/N 2881865 N690LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881196 N690NDAltitude Adjustment LLC · Lisle, ILBuilt 2006 · S/N 1851 N690PMMiddlefield Farm And Garden Co · Middlefield, OHBuilt 2024 · S/N 2881728 N690SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2678 N6911PMalo Blake Ridgway Trustee · Portland, ORBuilt 1985 · S/N 28-8590050 N6912JHammond Brian M · Gresham, ORBuilt 1976 · S/N 28-7690427 N6913JFlight Time LLC · Conover, NCBuilt 1976 · S/N 28-7690428 N6913RAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1985 · S/N 28-8590054 N6914JKreppel Frederick W · Wayne, PABuilt 1976 · S/N 28-7690429 N6915TSpier Samuel · Carson City, NVBuilt 1985 · S/N 28-8590058 N6915ZParks Stephen · Corpus Christi, TXBuilt 1985 · S/N 34-8533003 N69165Locaero Services Inc Trustee · Wilmington, DEBuilt 1985 · S/N 28-8516060 N6917DOlds Forge Flyers Inc · Lansing, MIBuilt 1985 · S/N 28-8590061 N6917GMarvell Aviation LLC · Marvell, ARBuilt 1985 · S/N 28-8590062 N691LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881197 N691MAMitchell Martin · Alpine, CABuilt 2002 · S/N 3257291 N691PSSkywest Leasing Inc · St George, UTBuilt 2006 · S/N 40.691 N691TSAl Systems Corp · Weston, FLBuilt 2020 · S/N 4984 N691YWGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2006 · S/N 40.690 N6920BSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1985 · S/N 34-8533025 N6920GValley Boys LLC · Lakeville, MNBuilt 1985 · S/N 28-8590065 N6922JSystematic Management And Flight Training LLC · Kankakee, ILBuilt 1976 · S/N 28-7690431 N692BMTexas Sea Ventures LLC · Laredo, TXBuilt 2012 · S/N 4636551 N692CFG&M Aircraft Inc · Wheat Ridge, COS/N 44-7995024 N692CJFlying High Again LLC · Smyrna, TNBuilt 2012 · S/N 40.1137 N692DSDeltasierra Aero Inc Trustee · Wilmington, DEBuilt 2006 · S/N 40.692 N692DWBroyles Danny Keith · New Castle, INBuilt 2005 · S/N 3257384 N692LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881217 N692STVanwiggeren David · Ottawa, ILBuilt 2015 · S/N 4636685 N6930JSkypark Aero Club Inc · Troy, OHBuilt 1976 · S/N 28-7690432 N6931JMissouri Valley Flying Club Inc · Culbertson, MTBuilt 1976 · S/N 28-7690433 N6932FBruns Luke J · Flower Mound, TXBuilt 1976 · S/N 28-7790174 N6935LBreidenbach Aviation LLC · Bettendorf, IABuilt 2014 · S/N 4116 N6938JBerry Joe O · Franklin, TNBuilt 1977 · S/N 28-7716001 N693CLin Steven C · Granite Falls, NCBuilt 2002 · S/N 0438 N693CDAber Air LLC · Amherst, OHBuilt 2004 · S/N 0976 N693CPCharlie Papa 1 LLC · Stafford, TXBuilt 2004 · S/N 1181

Back to AD 2008-06-28 R1