OpenAirDocs.org
AD 2016-07-21

Registered aircraft · 5,443

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:2016-07-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
  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.

N81036Precision Aviation LLC · Fayetteville, GABuilt 1979 · S/N 28-8090121N8103HAlleghany Flying Club Inc · Hyndman, PABuilt 1979 · S/N 28-8090116N8103QFlight Time Builders Inc · Memphis, TNBuilt 1979 · S/N 28-8090117N810AM5280 Flying Club LLC · Castle Pines, COBuilt 2022 · S/N 2881578N810DAMjh Aero Inc · Houston, TXBuilt 1978 · S/N 28-7816427N810NKAims Community College · Greeley, COBuilt 2020 · S/N 2881344N810UBoard Of Regents Of University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020230N8110FRobinson Ronald G · Ottawa, ILBuilt 1976 · S/N 28-7790234N8112CMidili Aldo D · Volcano, CAS/N 28-8016114N8112JRamsey Douglas Edward · Monument, COBuilt 1979 · S/N 28-8090124N8112QLongbranch Av8r LLC · Santa Rosa Beach, FLBuilt 1979 · S/N 28-8090125N81133Rafiq Abrahem · San Diego, CABuilt 1979 · S/N 28-8090133N8113BCapitol City Flyers Inc · Madison, WIS/N 28-8090128N8113HT4 Aviation LLC · Nine Mile Falls, WABuilt 1979 · S/N 28-8090129N8113KSalmon River Assets LLC · The Woodlands, TXBuilt 1979 · S/N 28-8090130N8113RShenk 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-8090135N8114FFlying 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-8016125N8119BChabrier 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-7890306N811BLWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 2881853N81202Registration 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-8090152N81250Sanchez Paul K · Boca Raton, FLFirst renewal noticeBuilt 1979 · S/N 28-8016147N8125YGlass Jody L · Indianapolis, INBuilt 1979 · S/N 28-8016146N81260Trusty Archer LLC · Ann Arbor, MIBuilt 1979 · S/N 28-8090155N8126MWest Hawaii Wingers Incorporated · Kailua Kona, HIBuilt 1979 · S/N 28-8016149N8126XB2fh Ltd · Allentown, NJBuilt 1979 · S/N 28-8090154
Back to AD 2016-07-21