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.

N278CMVarakantham Indra Sena Reddy · Allen, TXBuilt 2004 · S/N 40.391 N278DSRelm Air LLC · Wilmington, DEBuilt 2003 · S/N 40.278 N278ECAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 41745 N278GZNichols Industrial Construction Co Inc · Birmingham, ALBuilt 2023 · S/N 9535 N278JLarkin Matthew W · Lafayette, CABuilt 2002 · S/N 4697127 N278JAAerownership North American Services Inc Trustee · Wilmington, DEBuilt 2021 · S/N 5037 N278MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2881019 N278SREllsworth Farm LLC · Kingsbury, NYBuilt 2007 · S/N 2419 N278WDSnk LLC · Reisterstown, MDBuilt 2011 · S/N 3825 N279AGWings Over Texas Holdings LLC · Denton, TXBuilt 2020 · S/N 4496507 N279CAGorgoglione David · Rindge, NHBuilt 2006 · S/N 40.688 N279CGDelaware State University · Dover, DEBuilt 2000 · S/N 2843399 N279CPBarnard Henry H III · Albany, GABuilt 2008 · S/N 3221 N279JWinchester Aviation LLC · Winter Park, FLBuilt 2020 · S/N 2555 N279MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2881020 N279MTGmcm Aviation LLC · Central, SCBuilt 2007 · S/N 2470 N279PALamont Air LLC · Springtown, TXBuilt 2008 · S/N 4697366 N279PWMauck Ryan S Trustee · Bend, ORBuilt 1985 · S/N 28-8590059 N279STValiair Limited Co Trustee · Casper, WYBuilt 2006 · S/N 4697279 N27ACN27ac LLC · Westfield, MABuilt 2024 · S/N 9807 N27AUAndrews University · Berrien Springs, MIBuilt 2014 · S/N 2843768 N27AVA-V Aviation LLC · Swisher, IABuilt 2026 · S/N 11285 N27EMStair Colin · Brookfield, WIBuilt 2006 · S/N 1798 N27LGStilda One LLC · Fort Loramie, OHBuilt 2008 · S/N 3052 N27LTPitts Roger D DBA · Hickory, NCBuilt 1982 · S/N 32R-8213060 N27PFNorthstar Global Flight LLC · Bronxville, NYBuilt 2024 · S/N 9982 N27RZHq Wings LLC · Porterville, CAS/N 4636299 N27TRReid Thomas F · Epsom, NHBuilt 2023 · S/N 9437 N27WFKirby Trent · St George, UTBuilt 2020 · S/N 2598 N27WVN27wv LLC · Shortsville, NYBuilt 2004 · S/N 1031 N28011Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881346 N28015Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881347 N28017Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881348 N2801LAv8sgf LLC · Rogersville, MOBuilt 2017 · S/N 4475 N28020Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881349 N28027Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881350 N28029Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881351 N2802MSkyone Aero Services LLC · Castro Valley, CABuilt 1977 · S/N 28-7816312 N28030Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881352 N28034Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881357 N28043Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881358 N28045Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881359 N2804MEhrenborg Robert J · Fisherville, KYBuilt 1977 · S/N 28-7890269 N28051Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881360 N28053Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881379 N28065Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881380 N28069Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881381 N2806MCondor Aero Club Inc · Zelienople, PABuilt 1977 · S/N 28-7890270 N28077Cae Aviation Academy Phoenix LLC · Mesa, AZS/N 2881382 N28086Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881392

Back to AD 2008-06-28 R1