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.

N20LGYerena Mario Cesar Gutierrez · Bethel Island, CABuilt 1968 · S/N 28R-30491 N20LLFlying 20 Club Inc · Springfield, ILBuilt 1978 · S/N 28-7990119 N20PCMyrtlewood Aviation LLC · Tampa, FLBuilt 2007 · S/N 4697327 N20PN20pn LLC · Scottsdale, AZBuilt 2017 · S/N 2352 N20PTN20pt LLC · Wilmington, DEBuilt 2020 · S/N 4636771 N20PVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496649 N20QCHenderson Stephen L · Carthage, NCBuilt 1977 · S/N 28-7890227 N20SA Paradise Repo LLC · Nokomis, FLBuilt 1978 · S/N LW-267 N20SALc Air Leasing LLC · Treasure Island, FLBuilt 1976 · S/N 28-7690337 N20TACopperstone Fc LLC · Lancaster, PABuilt 2010 · S/N 2843677 N20TTCarew Robert W · Green Lake, WIBuilt 2019 · S/N 2497 N20UFCirrus 20 LLC · Gainesville, FLBuilt 2022 · S/N 8757 N20WEEvans Phyllis H Trustee · Riverside, CABuilt 1980 · S/N 441-0160 N20WJDiversified Air Services LLC · Edmond, OKBuilt 1993 · S/N 3448027 N20WSEmmer Michael Harold II · Aiken, SCBuilt 2004 · S/N 1406 N20XHDuley Air Wing Group LLC · Alpharetta, GABuilt 2025 · S/N 10538 N2102CGreat Northern Aircraft Inc · Griffith, INBuilt 1978 · S/N 28-7916130 N21030Aircraft Management Group Inc · Honolulu, HIBuilt 1978 · S/N 28-7816529 N2104NHammond Brian R · Lincoln University, PABuilt 1979 · S/N 28-7990271 N2104UVeracy Aviation LLC · Arlington, VABuilt 1979 · S/N 28-7990327 N21052Registered aircraftN-number assigned, not yet registeredS/N 28-7916023 N2105UPiper Automotive & Marine Service Inc · North Miami, FLBuilt 1979 · S/N 28-7990328 N21065Omni Management LLC · Decatur, ALS/N 28-7990033 N2106CRunde Dean G · Riceville, IAS/N 28-7916131 N2107DBreslow Arnold M · Dania, FLBuilt 1978 · S/N 28-7916142 N2107EFly Kilo Charlie LLC · New Century, KSBuilt 1978 · S/N 28-7916162 N2108CMetro Aircraft Co · Bloomington, MNBuilt 1978 · S/N 28-7990142 N2109NStallings Farms Trucking LLC · Hertford, NCBuilt 1979 · S/N 28-7990274 N210EZFaulkison Brian S · Watkins, COBuilt 1978 · S/N 28-7990077 N210FLChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 4496478 N210JEKoch Henry Thomas · Tampa, FLBuilt 2016 · S/N 4323 N210TAN210ta LLC · Jupiter, FLBuilt 2023 · S/N 9077 N21116Prestige Worldwide Aviation LLC · Downers Grove, ILBuilt 1978 · S/N 28-7916025 N2111FDhs Operations LLC · Wilmington, DEBuilt 1978 · S/N 44-7995153 N2111GScoggins Thomas H · Daytona Beach, FLBuilt 1979 · S/N 28-7990416 N2111MCarel Kenneth W · Corpus Christi, TXBuilt 1981 · S/N 32R-8113066 N2111SSchwab Jollina Michelle · Arlington, TXBuilt 1970 · S/N 28R-31048 N21123Paris Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916027 N2112FBank Of Utah Trustee · Salt Lake City, UTS/N 44-7995154 N2112GA&J Aircraft Leasing Inc · Burlington, COBuilt 1978 · S/N 28-7816367 N2112KRocky Mountain Aircraft Services LLC · Broomfield, COBuilt 1978 · S/N 28-7990234 N2112NV & R Aviation LLC · Georgetown, TXBuilt 1979 · S/N 28-7990276 N2112TMarsh James M · Polkton, NCBuilt 1971 · S/N 28R-7130002 N2112ZWilson Mickey Ray · Skagway, AKBuilt 1979 · S/N 28-7990394 N21131Emge Douglas W · Albertville, ALBuilt 1978 · S/N 28-7990035 N2113QGlenelg Equipment Leasing LLC · Hanover, MDBuilt 2018 · S/N 4710 N2114FChapel Hill Flying Club DBA · Sanford, NCBuilt 1978 · S/N 28-7916169 N2114JMonaco Joseph · Castleton, VTBuilt 1978 · S/N 28-7916224 N2114KRcs Services LLC · California, MDBuilt 1978 · S/N 28-7990235 N2115JMartin Aviation LLC · Bargersville, INBuilt 1978 · S/N 28-7916196

Back to AD 2008-06-28 R1