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.

N369STAero-Mobil Inc · Wilmington, DEBuilt 2006 · S/N 4636396 N369WTSterling John · Port Lavaca, TXBuilt 1978 · S/N LW291 N369ZDZelta Air LLC · Newark, DEBuilt 2025 · S/N 10702 N36BXCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10599 N36CCjd Aviation LLC · Essex, CTBuilt 2018 · S/N 4636730 N36CKCapri Air LLC · Danville, NHBuilt 2021 · S/N 2749 N36DBWalsh Terence G · Fort Lauderdale, FLBuilt 1978 · S/N 28-7890441 N36GAGrand Aviation LLC · Wilmington, DES/N 348433049 N36GWSky Whiddon Inc · Fort Lauderdale, FLBuilt 2023 · S/N 9551 N36MRCook Canyon (Gp) LLC · Dallas, TXBuilt 2018 · S/N 4631 N36PLBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2006 · S/N 1707 N36RECiconia Aeronautics LLC · Madison, MSBuilt 2013 · S/N 4636573 N3700MBoeing Co · Berkeley, MOBuilt 1980 · S/N LW-340 N3700TBrickner Gary K · North Highlands, CAS/N 28R-30004 N3701TStewarts Aircraft Service Inc · Waynesville, OHBuilt 1967 · S/N 28R-30005 N3702TDelp Thomas W · Rensselaerville, NYFirst renewal noticeBuilt 1967 · S/N 28R-30006 N3704TStevens Michael J · Punta Gorda, FLBuilt 1967 · S/N 28R-30008 N3705TN3705t LLC · Dallas, TXBuilt 1967 · S/N 28R-30009 N3706TFinished Work Aviation LLC · Redding, CABuilt 1967 · S/N 28R-30010 N3709TJudice Eric M · Elgin, ILFirst renewal noticeBuilt 1967 · S/N 28R-30013 N370BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 2881770 N370DCMarcantoni Henry W · Round Rock, TXBuilt 2008 · S/N 40.931 N370DSCarrera Group Inc · Glen Cove, NYBuilt 2008 · S/N 40.1019 N370GAir Land Ventures LLC · Highland Park, ILBuilt 2003 · S/N 0783 N370JGGuideair LLC · Eden Prairie, MNBuilt 2004 · S/N 1123 N370MKNorth Star Aviation Inc · Mankato, MNBuilt 2024 · S/N 2881802 N370SUOklahoma State University · Stillwater, OKBuilt 2020 · S/N 2615 N370TCD & J Aviation LLC · Apopka, FLBuilt 2006 · S/N 2842269 N3710MPrisbe Ernest · Los Altos Hills, CABuilt 1998 · S/N 3257039 N3711Gratech Management LLC · Washington, NCBuilt 1967 · S/N 28R-30015 N3716TN351xray LLC · Olga, WAS/N 28R-30021 N3718MFink Gary L · Klamath Falls, ORBuilt 1978 · S/N 28-7890325 N3718TRuder William A Jr · Council Bluffs, IAS/N 28R-30023 N371BGCzok Justin · Park Ridge, ILBuilt 2005 · S/N 41104 N371BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 2881771 N371CDEicholz Robert Trustee · Palm Springs, CABuilt 2005 · S/N 1434 N371CKFish Sandwich LLC · Orlando, FLBuilt 2003 · S/N 1307 N371DCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842189 N371ECNext1sr LLC · Dayton, OHBuilt 2025 · S/N 10487 N371JSV2j LLC · Bloomfield Hills, MIBuilt 2024 · S/N 9970 N371MKNorth Star Aviation Inc · Mankato, MNBuilt 2024 · S/N 2881803 N371PMElias Miguel A · Kenner, LAS/N 4371 N371RCCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11577 N3720TBrinmoore Aero LLC · Jacksonville, FLBuilt 1967 · S/N 28R-30025 N3722MRegistration Pending · Bulverde, TXRegistration pendingS/N 28-7890326 N3722XBig Bend Community College · Moses Lake, WABuilt 2018 · S/N 2881011 N3723XBig Bend Community College · Moses Lake, WABuilt 2018 · S/N 2881012 N3724MRegistration Pending · Greenville, SCRegistration pendingBuilt 1978 · S/N 28-7890327 N3724TGateway Flight Training LLC · Saint Louis, MOBuilt 1967 · S/N 28R-30030 N3727TN3727 Tango LLC · Baton Rouge, LABuilt 1967 · S/N 28R-30034

Back to AD 2008-06-28 R1