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.

N8113RShenk Steven S · Strasburg, PABuilt 1979 · S/N 28-8090131N8113XOsage Air Service Inc · Bridgeton, MOBuilt 1979 · S/N 28-8090132N81149Fly By Knight Inc · Hammond, LABuilt 1982 · S/N 28-8216110N8114ASummers Spraying Service Inc · Midland, TXBuilt 1979 · S/N 28-8090135N8114CLauterbach Coleman J · Hagerstown, MDBuilt 1968 · S/N 28R-30818N8114FFlying Country Club Inc · Coal Valley, ILBuilt 1979 · S/N 28-8090136N8115BBlue Horizons Flying Club Inc · Perrysburg, OHBuilt 1979 · S/N 28-8016116N8115HRivera Philip T · Las Vegas, NVS/N 28-8016117N8115LDouble Greene LLC · Spout Spring, VABuilt 1979 · S/N 28-8016119N8115PJla Aero LLC · State College, PABuilt 1979 · S/N 28-8016120N8116BAronbay LLC · Bartlett, ILBuilt 1979 · S/N 28-8016124N8116JChapel Hill Flying Club Inc DBA · Sanford, NCBuilt 1979 · S/N 28-8016125N8118XSchultz Robert J · Rapid City, SDBuilt 1979 · S/N 32R-8029011N8118ZWest Metro Aviation LLC · Buffalo, MNBuilt 1979 · S/N 32R-8029013N8119BChabrier Pierre H · Wesley Chapel, FLBuilt 1982 · S/N 28-8290092N8119CHenry Gary A · Narragansett, RIBuilt 1979 · S/N 28-8016126N8119HPiper Warrior LLC · Middleton, MABuilt 1979 · S/N 28-8016127N8119PStelling William F · Fairbury, NEBuilt 1979 · S/N 28-8016128N8119QBay Lux Ventures LLC · Tampa, FLBuilt 1979 · S/N 28-8016129N811ASS&A Flying LLC · Minden, NEBuilt 1978 · S/N 28-7890306N811ATDot Aviation LLC · Wilmington, DEBuilt 2014 · S/N 4496368N811BLWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 2881853N811CCArreic LLC · Crowley, TXS/N 1534N811DAJ D Aviation LLC · Statesboro, GABuilt 2008 · S/N 3008N811DR906 Aviation LLC · Escanaba, MIBuilt 2007 · S/N 2367N811ETGroup Five 24 LLC · Corvallis, ORBuilt 2007 · S/N 40.874N811EXWinters Michael · Longmont, COBuilt 2008 · S/N 3154N811GTSwift Flight LLC · Albuquerque, NMS/N 2283N811HJCarto/Flight Inc · Willoughby, OHBuilt 1981 · S/N 441-0208N811JTVicstar Aviation LLC · Cathedral City, CABuilt 2008 · S/N 3127N811LTCutlass Aviation LLC · Tucson, AZBuilt 2006 · S/N 1795N811RTSummit Aviation LLC · Nashville, TNBuilt 2008 · S/N 2917N811SRSa Fliers LLC · Venice, FLS/N 2270N811WMMann Daisy Salvalsa · Richland, WABuilt 2000 · S/N 1042N81202Registration Pending · Augusta, KSRegistration pendingBuilt 1979 · S/N 28-8016144N8120BGreat Northern Aircraft Inc · Griffith, INBuilt 1979 · S/N 28-8016134N8120FPray Aviation Inc · Augusta, KSBuilt 1979 · S/N 28-8016136N8120JCope Christopher J · Plumas Lake, CABuilt 1979 · S/N 28-8016140N8120MMckissick John R · Westminster, MDBuilt 1979 · S/N 28-8016141N8120XMccool Kenneth Wade · Olive Branch, MSBuilt 1979 · S/N 28-8016142N8121FKraack Stephen T · Lithia, FLBuilt 1979 · S/N 28-8016145N8121JSchluckebier Daniel C · Aldie, VABuilt 1979 · S/N 28-8090141N8121KRegistered aircraftBuilt 1979 · S/N 28-8090142N8122BErwin Mark N · Snyder, TXBuilt 1979 · S/N 28-8090149N8122HSchlesinger Richard J · West Cornwall, CTBuilt 1979 · S/N 28-8090151N8122QN8122q LLC · Venice, FLBuilt 1979 · S/N 28-8090152N8123CTurlock Fruit Company Inc · Turlock, CABuilt 1979 · S/N 32R-8013014N8124CSt Mark Ltd · Wilmington, DES/N 34-8233090N8124PClearsky LLC · Missouri City, TXBuilt 2003 · S/N 0651N81250Sanchez Paul K · Boca Raton, FLFirst renewal noticeBuilt 1979 · S/N 28-8016147
Back to AD 2008-06-28 R1