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.

N319RDN319rd LLC · Casa Grande, AZBuilt 1998 · S/N 4636139N319SKG - Raf Leasing LLC · Birmingham, ALBuilt 2021 · S/N 2772N319SRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2006 · S/N 1702N319TMCloudsail Aviation LLC · Princeton, NJBuilt 2024 · S/N 9993N319UWebb Automotive Group Inc · Farmington, NMBuilt 2015 · S/N 4636653N319WSStill Air Ventures Inc · Wilmington, DEBuilt 2010 · S/N 3677N31CKByrdstown Aviation LLC · Brentwood, TNBuilt 2020 · S/N 2604N31CPSkydoc Aviation LLC · Niskayuna, NYBuilt 2021 · S/N 2753N31DKScanlon Enterprises LLC · Charlotte, NCBuilt 2022 · S/N 8769N31EPNew Frontier Aviation LLC · Phoenix, AZBuilt 2009 · S/N 4697415N31GSParsons John Joseph · Winter Park, FLS/N 348433021N31GUBuyin Time LLC · Clearbrook, MNBuilt 2006 · S/N 2274N31JDLaural Aviation LLC · Banner Elk, NCS/N 4697246N31LHUp And Up Aviation LLC · Magnolia, TXBuilt 1977 · S/N 28-7816236N31MBThurman David L · Daytona Beach, FLBuilt 2019 · S/N 2470N31MVCypress Air Charter LLC · Estero, FLBuilt 2022 · S/N 8588N31SWBenwild Aviation LLC · Middleburg, VABuilt 2019 · S/N 4825N31WCPro Serve Aviation LLC · Englewood, COBuilt 1979 · S/N BB-465N31WLAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 0679N31WPSale Reported · Gaylord, MISale reported, pending cancellationBuilt 1974 · S/N LW-99N3200RTexeira David A · Venice, FLBuilt 1969 · S/N 28R-31126N3207RLingerfelt Joseph A · Woodburn, ORBuilt 1969 · S/N 28R-31129N320AUAuburn University · Auburn, ALBuilt 2020 · S/N 4496496N320CDSimpulse Inc · Oregonia, OHBuilt 2004 · S/N 1248N320DFDfig Holdings LLC · Kalispell, MTBuilt 2025 · S/N 11068N320DGSrs 320 LLC · Houston, TXBuilt 2023 · S/N 9402N320DRMontgomery Machine LLC · Guilford, CTBuilt 2005 · S/N 42064N320NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881618N320PGJuliet Delta Mike Aviation LLC · Erie, COBuilt 2007 · S/N 1878N320RLLast Flight Out LLC · Brentwood, TNBuilt 2006 · S/N 1854N320RRHighway Aero LLC · Bristow, VABuilt 2002 · S/N 0358N320SRUpindasky Now LLC · Santa Monica, CABuilt 2020 · S/N 2573N320SUOklahoma State University · Stillwater, OKFirst renewal noticeBuilt 2019 · S/N 2522N320TSSinclair Peter · Los Gatos, CABuilt 2003 · S/N 0771N320UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020227N3212QBrighters David E Trustee · Baton Rouge, LABuilt 1977 · S/N 28-7790443N3219RSotelo Aviation LLC · Naples, FLBuilt 1969 · S/N 28R-31132N321AGLeo Air LLC · Marietta, OKBuilt 2012 · S/N 4636563N321AZBuilders Aviation LLC · Algona, IABuilt 2003 · S/N 0508N321BGItinerant Orl LLC · Columbia, SCBuilt 2005 · S/N 1311N321BRFlyingu LLC · Austin, TXBuilt 2005 · S/N 1489N321BXBravo Xray LLC · Gainesville, FLBuilt 2007 · S/N 41799N321CFTekswork Aviation LLC · London, KYBuilt 2002 · S/N 0304N321CKFairwinds Aviation LLC · Goldsboro, NCBuilt 2004 · S/N 40.414N321DRSavakinas Alan M · Clarence, NYBuilt 1979 · S/N 28-8090011N321DTDt Air Adventures LLC · Salt Lake City, UTBuilt 2020 · S/N 2582N321ETVlt Aviation LLC · Tampa, FLBuilt 2025 · S/N 10940N321FLSkywalker Aviation LLC · Saint Paul, MNBuilt 2009 · S/N 3392N321FSUtah State University · Logan, UTBuilt 2004 · S/N 40.384N321GKBrown Water Associates LLC · Monticello, FLBuilt 2015 · S/N 4290
Back to AD 2008-06-28 R1