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.

N221EFMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881541 N221FLFox Leasing Group LLC · Hollywood, FLBuilt 2021 · S/N 4496524 N221GWPink Ibis Air LLC · Vero Beach, FLS/N 0381 N221JAInner Air Ity LLC · Pensacola, FLBuilt 2007 · S/N 2416 N221NDBamford Benjamin R Trustee · Middlebury, VTBuilt 2001 · S/N 2842110 N221PHFlorida Flight Physical LLC · Crystal River, FLBuilt 2019 · S/N 4872 N221RPPastor Randall J · Granite Bay, CABuilt 2004 · S/N 0878 N221STForza Management Co · Auburn, MABuilt 2014 · S/N 4636651 N221TRCorporate Hospitality Aviation LLC · Irving, TXBuilt 2021 · S/N 2659 N221TUMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881531 N221TVCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11128 N221TXSooner Aviation LLC · Helena, MTBuilt 2007 · S/N 2468 N221WBOtter Rock Aero LLC · Newport, ORBuilt 2005 · S/N 41091 N22204Anania Nickolas · West Ossipee, NHBuilt 1978 · S/N 28-7990071 N2221KInner Circle Air Group LLC · Dallas, TXBuilt 1978 · S/N 28-7916227 N2222BZeffiro Air LLC · Nashville, TNBuilt 1978 · S/N 28-7990129 N2222TDishman John David · Brooklyn, NYBuilt 1978 · S/N 28-7890490 N2223BN2223b LLC · Sandy, UTBuilt 1978 · S/N 28-7990130 N2223FCheatham Joseph H · Hopkins, SCS/N 28-7916187 N2223NSanders Mark Steven · Superior Township, MIBuilt 1979 · S/N 28-7990280 N2223QSnell Cameron · Wichita, KSBuilt 1977 · S/N 28-7716090 N2223RMoccasin Flying Club Inc · Chattanooga, TNBuilt 1979 · S/N 28-7990306 N2224KGordon John · Uniondale, NYS/N 28-7916228 N2225Ica Aviation LLC · Alexandria, VABuilt 2018 · S/N 4614 N2225DPaphos Airways LLC · Farmingdale, NYBuilt 1978 · S/N 28-7916152 N2225NMendair Aviation LLC · Miami, FLBuilt 1979 · S/N 28-7990281 N22266Oldenkamp David J · Payson, AZBuilt 1976 · S/N 28-7690208 N2226DJenkins Danny W · Nebo, KYBuilt 1978 · S/N 28-7990166 N2226NWingsleasing LLC · Wichita, KSBuilt 1979 · S/N 28-7990282 N2226XOmar Rawhi A · Crestwood, KYBuilt 1979 · S/N 28-7916355 N2226ZInternational Aviation Group LLC · Lake Wales, FLBuilt 1979 · S/N 28-7916390 N2227HHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 44-7995173 N2227RWilhite Randy J · Jackson, MIBuilt 1979 · S/N 28-7990309 N2227XMoravec Jason A · Houston, TXBuilt 1979 · S/N 28-7990369 N2227ZTwo Brothers Acquisitions LLC DBA · Perris, CABuilt 1979 · S/N 28-7916391 N2228ZThunderbird Aircraft Co · Bloomington, MNBuilt 1979 · S/N 28-7990408 N2229QM21 Aircraft Leasing LLC · Morganton, NCBuilt 1977 · S/N 28-7790383 N2229UCalifornia In Nice Inc DBA · San Jose, CABuilt 1979 · S/N 44-7995253 N2229YWehkamp Air LLC · Ingalls, KSBuilt 1979 · S/N 28-7990378 N2229ZGeorge Walker Field Inc DBA · Bedminster, NJBuilt 1979 · S/N 28-7990409 N222ADShroomdom Inc · Poplarville, MSBuilt 2006 · S/N 40.653 N222AEHelice Sarcelle LLC · San Antonio, TXBuilt 2024 · S/N 9978 N222AVCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1981 · S/N 34-8233006 N222BGBeaumont David Matthew · Orcutt, CABuilt 2004 · S/N 1095 N222BTBt4 Holdings LLC · The Villages, FLBuilt 2018 · S/N 4726 N222BUDarrowby LLC · Medina, MNBuilt 2026 · S/N 11318 N222BYRda Solutions LLC · Fort Worth, TXBuilt 2004 · S/N 41022 N222EDInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 1103 N222FS404 Church LLC · Wayne, PABuilt 2022 · S/N 4636810 N222GFFischer Edward T · Appleton, WIBuilt 2002 · S/N 40.230

Back to AD 2008-06-28 R1