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

N18JSAdelaar Holdings LLC · Missoula, MTBuilt 2016 · S/N 4636702N18KATreetoppers II LLC · Newark, DEBuilt 1978 · S/N BB-360N18LHKrystal Sky Aviation LLC · Melbourne, FLBuilt 1998 · S/N 32-57058N18SAWatkins Aviation LLC · Kenton, OHBuilt 2005 · S/N 1401N18WDSeferiadis David · North Wales, PABuilt 2017 · S/N 4513N18WGBest Way Flights LLC · Magnolia, TXBuilt 2015 · S/N 4250N18WRN18wr LLC · Mesa, AZS/N 28-8190185N1901HLuing Daniel M · Chippewa Falls, WIBuilt 1977 · S/N 28-7716059N1902HAbraxis Air LLC · Casa Grande, AZBuilt 1977 · S/N 28-7716060N1903HEsp Aviation LLC · Mason City, IABuilt 1977 · S/N 28-7790351N1904HSpyropoulos Basil P · Lake Geneva, WIBuilt 1977 · S/N 28-7790352N190BETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N LW-345N190BMHolbrook Aviation Assets LLC · Park City, UTBuilt 2023 · S/N 9381N190CDMontague Paul N III · Vancouver, WABuilt 2000 · S/N 1099N190CTN321sl LLC · Pompano Beach, FLBuilt 2018 · S/N 2461N190DCHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2001 · S/N 4496103N190DWSouthern Sky Ventures LLC · Lewes, DEBuilt 2003 · S/N 42002N190JHAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2010 · S/N 3660N190KCHi Fly Aviation LLC · Harrisonburg, VABuilt 2008 · S/N 4692090N190MALightning Aviation LLC · Gillette, WYBuilt 2004 · S/N 40.355N190RLCamair Leasing LLC · Granbury, TXBuilt 1972 · S/N LW-1N190SRFlyby Air LLC · New Orleans, LABuilt 2007 · S/N 2641N1913HOllie And Wally Airlines LLC · Auburn, WABuilt 1977 · S/N 28-7716061N1914HMiloud Chadd K · Fort Worth, TXBuilt 1977 · S/N 28-7716062N191BSChambers Jason Daniel · Marion, MTBuilt 2007 · S/N 2733N191BWSung Properties LLC · Visalia, CABuilt 2005 · S/N 1577N191CDInzerillo Richard C · West Coxsackie, NYBuilt 2000 · S/N 1100N191DBMeridian Logistics LLC · Forest Lake, MNBuilt 2005 · S/N 4697232N191DDN191dd Aviation LLC · Sheridan, WYBuilt 2019 · S/N 2471N191DWLexo Enterpirses · Houston, TXBuilt 2003 · S/N 42022N191JGBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2006 · S/N 1699N191JRLocke-Lane Aviation LLC · Statesville, NCBuilt 1975 · S/N LW144N191KMDodson International Parts Inc · Rantoul, KSS/N 0017N191LNSrr LLC · Central Lake, MIBuilt 2005 · S/N 1548N191MGN191mg LLC · New Bedford, MAS/N 4410315N191NDMoore Aviation Inc · Beaver Falls, PABuilt 1989 · S/N 4495003N191TMHatfield Mfg Inc · Gooding, IDBuilt 2008 · S/N 4692042N1921JPjet Holdings LLC · Chattanooga, TNBuilt 2013 · S/N 4636606N1923PPremium Air LLC · Hibbing, MNBuilt 2018 · S/N 4610N1926A1926a LLC · Auburn, ALBuilt 1981 · S/N BB-922N192AMN34cc LLC · Liberty, NCBuilt 2021 · S/N 2881507N192BSIntoodeep Industries LLC · Palm Bay, FLS/N 2753N192BWChirles Michael A · Weston, CTBuilt 2006 · S/N 1625N192DSRmg Aviation LLC · Bal Harbour, FLBuilt 2005 · S/N 40.576N192LAMagnum Securities LLC · Sarasota, FLBuilt 2015 · S/N 40.1192N192PPiper Aircraft Inc · Vero Beach, FLS/N 28020294N192PGRhoads William M · Williamsburg, VABuilt 2008 · S/N 1923N192STKoehler Aviation LLC · Bend, ORBuilt 2013 · S/N 4692192N192TMWalker Randy · De Queen, ARBuilt 2005 · S/N 1578N1934HMaloney Loran D · Barnhart, MOBuilt 1977 · S/N 28-7716065
Back to AD 2008-06-28 R1