OpenAirDocs.org
AD 2008-06-28 R1

Registered aircraft · 16,295

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
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.

N1360CPinnacle Aviation LLC · Valdosta, GABuilt 2003 · S/N 0518N1362HRegion Flyers LLC · Valparaiso, INS/N 28-7716018N1362TKcon Airplane LLC · Kalispell, MTS/N 41789N1364NK & K Adventures · Wilmington, DEBuilt 2006 · S/N 41687N1368CCarson Dale Etrustee · Murrieta, CABuilt 2003 · S/N 0538N136AKGamma2 Inc · San Diego, CAFirst renewal noticeBuilt 2010 · S/N 3510N136AVHarford Archer Owners Group LLC · Bel Air, MDBuilt 1984 · S/N 28-8590004N136DSHemisphere Dancer LLC · Fripp Island, SCS/N 40.455N136DWSun Aircraft Management LLC · Ormond Beach, FLBuilt 2003 · S/N 4496168N136FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290171N136HHCirrus Design Corp · Duluth, MNBuilt 2019 · S/N 4865N136NGuthrie Richard D · San Clemente, CABuilt 2012 · S/N 40.1156N136RWEquity Estates LLC · Kalispell, MTBuilt 2010 · S/N 2064N136TTTyulyaev Vitaly N · Chesterfield, MOBuilt 2010 · S/N 411161N1374LB&B Exploration LLC · Lighthouse Point, FLBuilt 2006 · S/N 41579N1377HParis Air Inc · Vero Beach, FLS/N 28-7716019N1379C79 Charlie LLC · Knoxville, TNS/N 0541N137ATChamerlik William S · Spencer, TNBuilt 1977 · S/N 28-7816087N137BCJrnd Corp · Lewes, DEBuilt 2003 · S/N 2843584N137GBCalm Air Aviation · Nunica, MIBuilt 2006 · S/N 42538N137KCErmg-1 Holdings LLC · Coral Springs, FLFirst renewal noticeBuilt 2011 · S/N 40.1130N137KMAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2001 · S/N 4697091N137LUAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 1021N137NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 28010008N137PEB & C Aero LLC · San Luis Obispo, CABuilt 2001 · S/N 0008N137SRForeman Guy W · Valparaiso, INS/N 1916N1382CBerman Aviation LLC · Tulsa, OKBuilt 2003 · S/N 0534N1382HCaba Edward M · Malvern, PAS/N 28-7790309N1382VPropair400 LLC · Middletown, DEBuilt 2006 · S/N 41653N1386HRodriguez Luis D · Davenport, FLBuilt 1977 · S/N 28-7790310N138AFSchultz David · Murfreesboro, TNBuilt 2006 · S/N 41702N138BCUniversidad Interamericana De Puerto Rico · Bayamon, PRBuilt 2003 · S/N 2843580N138BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881955N138CKMako Medical Laboratories LLC · Raleigh, NCBuilt 2009 · S/N 3492N138CMMam Consulting LLC · Keller, TXBuilt 2014 · S/N 4697579N138CRValiair Ltd Co Trustee · Casper, WYBuilt 2005 · S/N 1584N138DSLance Murray Aviation LLC · San Marcos, CABuilt 2002 · S/N 40.238N138FCUsda Forest Service Fepp · Tallahassee, FLBuilt 1982 · S/N 28-8290102N138MCCherington Cirrus LLC · Belmont, MABuilt 2019 · S/N 4755N138MFN138mf LLC · Opa Locka, FLBuilt 2008 · S/N 1938N138VAMysky LLC · Saint Louis, MOBuilt 2023 · S/N 28020112N138YNw Ventures LLC · Palo Alto, CAS/N 4697505N1393WWvl Aviation Inc · Wilmington, DEBuilt 2006 · S/N 42531N1395VBliz Aviation LLC · Bend, ORBuilt 2006 · S/N 41667N139CDCirrus Design Corp · Duluth, MNS/N 0820N139DCLegacy Air LLC · Missoula, MTBuilt 2005 · S/N 41056N139FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290174N139JMPegasus Medical Management LLC · Wilmington, DES/N 2742N139KSpectrum Air LLC · Leesburg, VABuilt 2016 · S/N 2338N139LFLgd Properties Inc · Wylie, TXBuilt 2011 · S/N 4636505
Back to AD 2008-06-28 R1