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.

N287RLSouthshore Aviation LLC · Saint Joseph, MIBuilt 2008 · S/N 4697342 N287THTh Aviation LLC · Savannah, GABuilt 2019 · S/N 4807 N2881Cable Aviation Inc · Redwood City, CABuilt 2017 · S/N 2353 N2882CG & M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 44-7995302 N28842Turnquest Joad · Sanford, NCBuilt 1979 · S/N 28-7916417 N2884DThree Wing Flight School LLC · Stratford, CTBuilt 1979 · S/N 28-7916504 N2884LPurdue Aviation LLC · West Lafayette, INBuilt 1979 · S/N 28-7916507 N2884XAngle Of Attack Flying Company LLC · Springfield, MOBuilt 1979 · S/N 28-7916511 N28852Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843732 N2885BIxi LLC · West Bloomfield, MIS/N 28-7916513 N2885DLehigh Valley Flying Club Inc · Lehigh Valley, PABuilt 1979 · S/N 28-7990520 N2885FDunkly Daniel L · Chico, CABuilt 1979 · S/N 28-7990521 N2885GWisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 28-8090001 N2885KDierkes Steven P · Henderson, NVBuilt 1979 · S/N 28-7990525 N2885MGuilford Lakes Aviation LLC · Greensboro, NCS/N 28-7990526 N2885NBrandy Wine Flight School · West Chester, PAS/N 28-7990527 N2886KTallman George L Jr · Ocala, FLBuilt 1979 · S/N 28-7990529 N2886XMiller Robert Joseph · Fence Lake, NMBuilt 1979 · S/N 28-7990530 N28887Danos Laura S · Hampton Falls, NHBuilt 1979 · S/N 28-7990432 N28890Slocum Chad W · Pleasant Grove, UTS/N 28-7990433 N288BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881751 N288CBCalifornia Baptist University · Riverside, CABuilt 2023 · S/N 2881635 N288HGGeorgia Aviation Authority · Eastman, GABuilt 2002 · S/N 2842144 N288HPChaikin Steven · Kaunakakai, HIBuilt 2001 · S/N 2843482 N288MJRocky Ford Leasing LLC · Tallahassee, FLBuilt 2020 · S/N 4906 N288PASkywest Leasing Inc · St George, UTBuilt 2002 · S/N 2843502 N288PKJdc Aero LLC · Champaign, ILBuilt 2011 · S/N 2089 N288TGSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2015 · S/N 4636682 N288TSAlpha Blue Aviation LLC · Menlo Park, CABuilt 2021 · S/N 2763 N28907Warren Scott D · Lucerne, CABuilt 1979 · S/N 28-7990434 N28926Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881233 N28934Johnson Grant M · Odessa, FLBuilt 1981 · S/N 32R-8129008 N2893CChapel Hill Flying Club DBA · Sanford, NCS/N 28-7916517 N2893LKhalaf Maher · Canton, MIBuilt 1979 · S/N 28-7916520 N2893MRls Rental Co Inc DBA · Joplin, MOBuilt 1977 · S/N 28-7816321 N2893ZElite Aviation Of The Carolinas LLC · Tobaccoville, NCS/N 28-7990533 N28949Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881257 N2894BBarthell Burley O · Saint Johns, FLS/N 28-7990535 N2894MHernandez Michael A · Stockton, CABuilt 1977 · S/N 28-7816322 N28958Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881258 N28959Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881259 N28978Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881280 N28979Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881282 N2897MInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 28-7816323 N289BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881752 N289DAHarden Aviation LLC · Washington, PABuilt 2011 · S/N 2082 N289DSMidwest Avtech Inc · Peru, ILBuilt 2003 · S/N 40.289 N289EMorrison Matthew J · Waco, TXBuilt 2022 · S/N 9035 N289HGGeorgia Aviation Authority · Eastman, GABuilt 2002 · S/N 2842146 N289HPLemon And Black LLC · Raleigh, NCBuilt 2003 · S/N 2843544

Back to AD 2008-06-28 R1