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.

N365MBAmg Aviation LLC · Marlton, NJBuilt 2016 · S/N 4349 N365MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881688 N365PMValiair Lc Trustee · Casper, WYBuilt 2008 · S/N 3081 N365TGSuperior Transportation LLC · Belcamp, MDBuilt 2022 · S/N 8618 N365WDIsaiah4031 LLC · Santa Rosa Beach, FLBuilt 2014 · S/N 4042 N36601Frett Dennis R · Windsor, MOBuilt 1978 · S/N 28-7816671 N36602B2 W Corporation · Winona, MNBuilt 1978 · S/N 28-7816672 N36603J&J Holdings Of Pella LLC · Pella, IABuilt 1978 · S/N 28-7816673 N366CACavorite Aviation LLC · Lehi, UTBuilt 1998 · S/N 2843135 N366CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 1369 N366CPSnsg Properties LLC · Virginia Beach, VABuilt 2008 · S/N 3049 N366DMSwaggart Paul Blake · Touchet, WABuilt 2005 · S/N 1625 N366GWK&K Leasing Inc · Tea, SDBuilt 1979 · S/N LW-320 N366LDHorizon Aviation LLC · Johnson City, TNBuilt 2019 · S/N 4792 N366MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881689 N36700Archuleta Jeffrey Michael · Abilene, TXBuilt 1978 · S/N 28-7890526 N36711N36711 Piper LLC · Provo, UTS/N 28-7890527 N36789Paschke Jay · Weatherford, TXBuilt 1978 · S/N 28-7890530 N367BMWilliams Richard · Atlanta, GABuilt 2005 · S/N 1647 N367CPKafil Jason · Covina, CABuilt 2008 · S/N 3050 N367HMCoastal Streets LLC · Marblehead, MABuilt 2015 · S/N 4210 N367HRArrow Flight LLC · Baton Rouge, LABuilt 2000 · S/N 3257173 N367KRYance International LLC · Mobile, ALBuilt 2006 · S/N 2162 N367MKNorth Star Aviation Inc · Mankato, MNBuilt 2024 · S/N 2881746 N367PTHalcomb Robby · Burleson, TXBuilt 2012 · S/N 3854 N367TMTm Ventures LLC · Missoula, MTBuilt 2009 · S/N 3590 N367USEdic Silva LLC · Monte Sereno, CAS/N 40.846 N36800Fly Aviation Corp · Wilmington, DEBuilt 1978 · S/N 28-7816658 N368CDSavfar Aviation Inc · Wilmington, DEBuilt 2004 · S/N 1071 N368DMNosrati David · Beverly Hills, CABuilt 2007 · S/N 2433 N368FDOakes Farms Food & Distribution Services LLC · Naples, FLBuilt 2019 · S/N 4858 N368MKNorth Star Aviation Inc · Mankato, MNBuilt 2024 · S/N 2881776 N368PLCti Aircraft Leasing LLC · Memphis, TNS/N 2881296 N368RTBaldhill Flying Partners Llp · Binford, NDBuilt 1978 · S/N 28-7890531 N368SAIrish Sidney D · Roosevelt, NYBuilt 1968 · S/N 28R-30919 N368SPValiair Lc Trustee · Casper, WYBuilt 2026 · S/N 11636 N368ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881646 N3695MTreanor James J · Wolcott, CTBuilt 1978 · S/N 28-7890323 N3699ML A B Flying Service Inc · Renton, WABuilt 1978 · S/N 28-7890324 N369ALInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 1552 N369BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 2881769 N369BWHilliard Richard W · Southern Pines, NCBuilt 2007 · S/N 41791 N369CParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020223 N369CHLiberty Leasing Ix LLC · Melbourne, FLBuilt 2007 · S/N 2665 N369JDVitale Baxter 2 Llp · Baxter, MNBuilt 2010 · S/N 3686 N369JPWaddell Patrick G · Seattle, WABuilt 2003 · S/N 40.310 N369KBLowery Ted · Raleigh, NCBuilt 2007 · S/N 40.878 N369PCPine Holdings LLC · Broken Bow, OKBuilt 2020 · S/N 4916 N369SESkyfusion II LLC · Atlanta, GABuilt 2004 · S/N 0846 N369SFFlying Pig Express II LLC · Bucyrus, OHBuilt 2008 · S/N 3087

Back to AD 2008-06-28 R1