OpenAirDocs.org
AD 2008-06-28 R1

Registered aircraft · 16,284

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.

N9263LSkyhawk Flying Club Inc · Franklin Grove, ILBuilt 1996 · S/N 2843023N9264AArcher II Holding Company LLC · Coral Gables, FLBuilt 1985 · S/N 32R-8613003N9265BMlr Aviation LLC · Tavernier, FLBuilt 1996 · S/N 3246029N9265PWard Benny · Raleigh, NCS/N 2843024N9265RNielsen Robert Arthur · Lynnfield, MABuilt 1996 · S/N 4636030N9267QKandasamy David · Irvine, CABuilt 1996 · S/N 4636032N9267RN9267r LLC · Pittstown, NJBuilt 1996 · S/N 3246025N9269FSmith Outdoor Adventures LLC · Panama City, FLBuilt 1996 · S/N 3246039N9269GLauterbach Dean C · Newton, IABuilt 1996 · S/N 2843021N9269QAero-Tech Services Inc · Lititz, PABuilt 1996 · S/N 2843031N926CAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 2881040N926CDZimmerman Aircraft Rentals Inc · Friedens, PABuilt 2002 · S/N 0351N926CKFly By Numbers LLC · Tallahassee, FLBuilt 1976 · S/N 28-7690327N926DCTt Aviation LLC · Henderson, TXS/N 0926N926DMTurner Strategic Technologies LLC · Norfolk, VABuilt 2022 · S/N 8568N926JDJosephs Howard I · Edgartown, MABuilt 2007 · S/N 4636422N926KWClear Sky LLC · Newmarket, NHBuilt 2022 · S/N 8681N926PACoco Aircraft Inc · Merritt Island, FLBuilt 1999 · S/N 2843289N926TK8 Point Aviation LLC · Waltham, MABuilt 2022 · S/N 8622N926WGDollar Aviation LLC · Bainbridge, GABuilt 2020 · S/N 4911N9270BKenneson Jack A · Clarion, PABuilt 1996 · S/N 2843032N92714Registered aircraftBuilt 1996 · S/N 4636042N92717Hold Fast Property LLC · Alto, NMBuilt 1996 · S/N 4636043N92728Washington International Aviation LLC · Washington, DCBuilt 1996 · S/N 4636050N9272LValira Aviation II LLC · Oakland, CABuilt 1997 · S/N 2843077N9273BAll-In Aviation LLC · Fort Myers, FLBuilt 1996 · S/N 3246035N9273VLfc Solutions LLC · San Antonio, TXBuilt 1996 · S/N 3246036N92743Dulles Aviation Inc · Bristow, VABuilt 1997 · S/N 4496014N9274QTen Hi Flyers Inc · Denver, COBuilt 1996 · S/N 3246038N9274YFlight Club 502 Inc · Louisville, KYBuilt 1985 · S/N 28-8616020N9275XBarrakuda Ltd · Bend, ORBuilt 1996 · S/N 3246041N92765N92765 Inc Trustee · Wilmington, DEBuilt 1996 · S/N 4636070N9276CRegistration Pending · Kissimmee, FLRegistration pending, pending cancellationBuilt 1978 · S/N 28-7816454N92779Montana Land Properties LLC · Missoula, MTBuilt 1996 · S/N 3246047N9277BFishers Shop Inc · Xenia, OHBuilt 1996 · S/N 3246057N9277DBird Acquisition LLC · Phoenix, AZBuilt 1996 · S/N 2843047N9277FKrushefski Chet W · Cedar Park, TXBuilt 1996 · S/N 3246042N9279JAndromeda Air LLC · Houston, TXBuilt 1997 · S/N 2843068N927CDCotton Stephen P · Midland, MIBuilt 2002 · S/N 0227N927DBBrummett Enterprises Of Somerset LLC · Somerset, KYBuilt 2016 · S/N 4351N927DKInspirate Aviation LLC · Appleton, WIBuilt 2025 · S/N 10805N927GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881075N927KCFritz Rodney A · Lanark, ILFirst renewal noticeBuilt 2006 · S/N 41659N927PADuncan Michael J · Danville, VABuilt 1977 · S/N 28-7716082N927PPMartinez Lizette · Winter Park, FLBuilt 2003 · S/N 1367N927ROzinga Aviation Inc · Mokena, ILBuilt 2011 · S/N 4636509N927SFShared Flight N927sf LLC · Berryville, VABuilt 2006 · S/N 2238N927SUOhio State University · Columbus, OHBuilt 2021 · S/N 4496528N927VBR A Burch Construction Co Inc · Ramona, CABuilt 2008 · S/N 4692066N927WABradford J Thompson · Blacklick, OHBuilt 2006 · S/N 1807
Back to AD 2008-06-28 R1