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.

N2240KBurnet David A · Quinton, ALBuilt 1978 · S/N 28-7916233 N2241GOwens Wilbur · Rch Palos Vrd, CABuilt 1978 · S/N 28-7990229 N2241KFlickinger Charles · Hermitage, PABuilt 1978 · S/N 28-7916236 N2241WRonlin Inc · Kissimmee, FLBuilt 1979 · S/N 28-7916338 N2241YHenault Benjamin · Archdale, NCBuilt 1979 · S/N 28-7990386 N2242UAir-Mods Flight Academy Inc · Robbinsville, NJBuilt 1979 · S/N 44-7995259 N2242WKikhtenko Dmytro · Horse Shoe, NCBuilt 2025 · S/N 10831 N2243PEasterling Richard V DBA · Berkeley, CABuilt 1979 · S/N 28-7990295 N2244MParis Air Inc · Vero Beach, FLBuilt 1977 · S/N 28-7816261 N2244VSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1979 · S/N 28-7916329 N2245KPfeiffer Carl A Trustee · Moline, ILBuilt 1978 · S/N 28-7916237 N2245UFarris Gregory A · Chesterfield, MOBuilt 1979 · S/N 28-7916133 N2245WDorans Aviation LLC · Yardley, PABuilt 1979 · S/N 28-7990354 N2246HHanover Flying Club LLC · Mechanicsville, VABuilt 2014 · S/N 4127 N22473Miller Aviation Group LLC · Coon Rapids, MNBuilt 1978 · S/N 28-7916071 N2247BD & L Aircraft Leasing LLC · Ormond Beach, FLBuilt 1978 · S/N 44-7995108 N2247DSky Venture Inc · Franklin, WIS/N 28-7990168 N2247KSkyline Solutions Unlimited LLC · Edgewater, FLBuilt 1978 · S/N 28-7916238 N2247RSkaggs Erik Jerome · Tupelo, MSBuilt 2017 · S/N 4534 N2248D2 Wings LLC · Noblesville, INS/N 28-7990169 N2248UNorth Central Flight Center LLC · Warwick, RIFirst renewal noticeBuilt 1979 · S/N 28-7916316 N2249KGarner William B · Argyle, TXBuilt 1978 · S/N 28-7990239 N2249TKrause Michael B · Camarillo, CABuilt 1979 · S/N 28-7990318 N2249VMystere Flying Club Inc · Little Ferry, NJFirst renewal noticeBuilt 1979 · S/N 28-7990347 N224ARAvtac Solutions LLC · Oneida, TNBuilt 2001 · S/N 0137 N224AVAirplanesusa LLC · Schaumburg, ILS/N 2324 N224BGSlo Cal Aviation LLC · Arroyo Grande, CABuilt 2017 · S/N 4469 N224BSHoff Brian D · Spearfish, SDFirst renewal noticeBuilt 2004 · S/N 40.428 N224BTCacchiotti Lawrence F · Yakima, WABuilt 2002 · S/N 0370 N224CDAaron Brothers · Hinsdale, MABuilt 2001 · S/N 1127 N224CESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2016 · S/N 4396 N224CFTitan Land Company LLC · Medford, ORS/N 2926 N224CZTeal Skies LLC · Wilmington, DEBuilt 2011 · S/N 3771 N224DAAiralley LLC · Kingsport, TNBuilt 2008 · S/N 2988 N224DDDe Maio Dorian Albert · Las Vegas, NVBuilt 2007 · S/N 2625 N224DGFahrer Scott M · Sunrise Beach, MOBuilt 2002 · S/N 0275 N224EBVasquez Aviation LLC · Lake Placid, FLBuilt 2005 · S/N 1287 N224EJGlenn Air LLC · Ponte Vedra Beach, FLBuilt 2023 · S/N 9476 N224ELNrcme Training Systems LLC · Breese, ILBuilt 1977 · S/N 28-7716238 N224FRVictor 93 LLC · Hummelstown, PABuilt 2008 · S/N 2953 N224GRHaufe Nicole C · Madeira Beach, FLBuilt 2003 · S/N 0626 N224HFHallock Scott A Sr · Oneida, TNFirst renewal noticeS/N 0255 N224JC109 Ventures & Agency Services Inc · Glenburn, MEBuilt 2004 · S/N 0914 N224JF224jf LLC · Waterford, MIBuilt 2006 · S/N 2031 N224JGGuillory Mark T · Pineville, LABuilt 2004 · S/N 1013 N224JJCox Gerald Lee · Shepherdsville, KYBuilt 1994 · S/N 4622155 N224KRJds Holdings LLC · Oneida, TNBuilt 2002 · S/N 0179 N224LRCamp95 Enterprises LLC · Wheeling, WVBuilt 2002 · S/N 0155 N224LSForgotten Coast Flyers LLC · Naples, FLBuilt 2018 · S/N 2414 N224LZMazzia Aviation Partners LLC · Alpine, WYBuilt 2007 · S/N 2767

Back to AD 2008-06-28 R1