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.

N682LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881245 N682RMHuebel Ross · Houston, TXBuilt 2007 · S/N 2577 N682SRMajdalani Maher J · Perrysburg, OHBuilt 2007 · S/N 2691 N682TFAir Fleet Holdings LLC · Addison, TXBuilt 2025 · S/N 2881882 N682YTVan Bortel Aircraft Inc · Arlington, TXBuilt 2006 · S/N 41703 N6830WRocket Airways LLC · Verona, WIBuilt 2023 · S/N 9237 N6832FJpf Ventures LLC · Owatonna, MNBuilt 1976 · S/N 28-7790165 N6833FPatriot Aviation LLC · Huntington, INBuilt 1976 · S/N 28-7790166 N6839RGolden Wings LLC · Tampa, FLBuilt 2002 · S/N 0405 N683ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 2010 · S/N 4496286 N683CAFort Wayne Aircraft LLC · Fort Wayne, INBuilt 2024 · S/N 9868 N683DMMcmorphy LLC · Erie, PABuilt 2009 · S/N 3427 N683JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020083 N683LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881246 N683RHMente Et Manu LLC · Wilmington, DEBuilt 2018 · S/N 2427 N683SRTf Global LLC · Houston, TXBuilt 2007 · S/N 2766 N683WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 9897 N6840TJkak Services LLC · Sheridan, WYBuilt 1982 · S/N 441-0299 N6847JMarkle Rick S · Waddy, KYS/N 28-7690408 N6848JPrudent Paths LLC · Hillsborough, CABuilt 1976 · S/N 28-7690409 N684APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843780 N684ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 2010 · S/N 4496287 N684AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2025 · S/N 11011 N684BCRegistered aircraftBuilt 2005 · S/N 1295 N684CDFreedom Development Corporation LLC · Matthews, NCS/N 1786 N684DMMidwest Aviation Equipment LLC · Solon, IABuilt 2019 · S/N 4774 N684JAYale Companies LLC DBA · Indianapolis, INS/N 28020084 N684KMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2008 · S/N 4697353 N684LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881251 N684NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881151 N684SRPelair LLC · Milton, DEBuilt 2007 · S/N 2816 N6851XUpper Peninsula Aviation LLC · Kingsford, MIBuilt 1981 · S/N 441-0212 N6852FBlue Sky Flying Club LLC · Granger, IABuilt 1976 · S/N 28-7790167 N6854JTerwilliger John E · Hegins, PABuilt 1976 · S/N 28-7690410 N6855JLord Robert B Trustee · Lamar, COBuilt 1976 · S/N 28-7690411 N6856JWancho Brian J · El Paso, TXS/N 28-7690412 N685ATTexas Flight Training Aircraft 8 LLC · Wilmington, DES/N 4496288 N685AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2025 · S/N 11059 N685BMHeavenly Flight LLC · Cumming, GABuilt 2026 · S/N 11352 N685CDGraves Koene R Trustee · Paso Robles, CABuilt 2006 · S/N 1768 N685DMMetcalf Steven · West Union, IABuilt 2002 · S/N 0322 N685JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020085 N685LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881252 N685MAYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020143 N685MBHeavenly Flight LLC · Mount Pleasant, SCBuilt 2023 · S/N 9546 N685NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881305 N685SRRegistration Pending · Seattle, WARegistration pendingBuilt 2007 · S/N 2586 N685USBeard Eric D · Bakersfield, CABuilt 2006 · S/N 40.635 N6860JApm Leasing LLC · Casper, WYBuilt 1976 · S/N 28-7690413 N6861FParker Helicopters Inc · Watsonville, CAS/N 28-7790168

Back to AD 2008-06-28 R1