OpenAirDocs.org
AD 81-11-02 R1

Registered aircraft · 1,753

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:81-11-02-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:81-11-02-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.

N9401CRegistered aircraftBuilt 1978 · S/N 28R-7837197N9401NJanes Charles Dale · Cleburne, TXBuilt 1969 · S/N 28R-35112N9404N9404n LLC · Brush Prairie, WABuilt 1969 · S/N 28R-35115N9408NCope Parrish B · Lemoore, CABuilt 1969 · S/N 28R-35120N940TCMusser John R · Freeport, ILBuilt 1975 · S/N 28R-7535320N9411NFeicht Robert E · Rincon, GABuilt 1969 · S/N 28R-35123N9413NMartin Bernard · Maricopa, AZBuilt 1969 · S/N 28R-35126N9415NSky Bound LLC · Wyoming, MIBuilt 1969 · S/N 28R-35127N9417KWest Bend Air Inc · West Bend, WIBuilt 1976 · S/N 28R-7635236N9417NPrescott Milton B Jr · Glendive, MTBuilt 1969 · S/N 28R-35129N941NZCumplido Luis · Rumford, RIBuilt 1977 · S/N 28R-7737172N9420NSpace Cadets Inc · El Cajon, CAS/N 28R-35132N9421NMitzoom Montana LLC · Lakeside, MTBuilt 1969 · S/N 28R-35133N9423NCox Ricky L · Bell Buckle, TNBuilt 1969 · S/N 28R-35135N9425NSpaniol Mark · Lula, GABuilt 1969 · S/N 28R-35137N9426NClodfelter Chet · Roachdale, INBuilt 1969 · S/N 28R-35138N9427NSchool Board Of Bay County Fl · Panama City, FLS/N 28R-35139N9428NYatteau Michael G · Woodbridge, CABuilt 1969 · S/N 28R-35140N9430NOakley Air LLC · Oakley, MIBuilt 1969 · S/N 28R-35142N9435NDoran Jeffrey · Centerburg, OHS/N 28R-35148N9440NEshowe Aviation Inc · East Peoria, ILBuilt 1969 · S/N 28R-35154N9442NClear2aviate LLC · Ionia, MIBuilt 1969 · S/N 28R-35156N9443NSchulz John B Jr · Marquette, MIBuilt 1969 · S/N 28R-35157N9447NEvans Jeff W · Hannibal, MOBuilt 1969 · S/N 28R-35162N9448NMason Harold R · Quincy, WABuilt 1969 · S/N 28R-35163N9449NCole Vincent J · Ewa Beach, HIFirst renewal noticeBuilt 1969 · S/N 28R-35164N944DBManning David A · Aledo, TXS/N 2844109N9451NHorus Aviation LLC · Ashburn, VABuilt 1969 · S/N 28R-35166N9453NBroody George E Jr · Berwick, PABuilt 1969 · S/N 28R-35168N9455NSchreiber Jeffrey H · Mundelein, ILBuilt 1969 · S/N 28R-35170N9457NHermes Aviation Partners LLC · Boca Raton, FLBuilt 1969 · S/N 28R-35172N9458NSwaz Aviation LLC · Mesa, AZBuilt 1969 · S/N 28R-35174N9459NEngel Stephen J · Plymouth, INBuilt 1969 · S/N 28R-35175N9461NJames Neville & Company Inc · Ocala, FLBuilt 1969 · S/N 28R-35177N9462NLombardo Gene S · New Bern, NCBuilt 1969 · S/N 28R-35178N9464NTempleton Katherine M · Madison, WIBuilt 1969 · S/N 28R-35180N9465NStenhouse Place I LLC · Fountain Inn, SCBuilt 1969 · S/N 28R-35181N9466KSpanaflight LLC · Puyallup, WABuilt 1976 · S/N 28R-7635244N9466NWingert Douglas L · Smithfield, KYBuilt 1969 · S/N 28R-35182N9470NEdwards Ed · Collinsville, OKS/N 28R-35187N9471CHitpas Henry R II · Beaufort, SCBuilt 1978 · S/N 28R-7837200N9474NA-G-E Corp · Fort Pierre, SDS/N 28R-35191N9476NScheigert Delbert F Jr · Tucson, AZBuilt 1969 · S/N 28R-35193N9478NChadwick Aviation Services LLC · Monroe, CTBuilt 1969 · S/N 28R-35196N9480NHernandez Luis · Surprise, AZS/N 28R-35198N9481NKing Cindy · Purvis, MSBuilt 1969 · S/N 28R-35199N9484NBourjeili Elias · Glendora, CABuilt 1969 · S/N 28R-35202N9486NRahimi Navid B · Silver Spring, MDBuilt 1969 · S/N 28R-35205N9491NWalker Mark L · Turlock, CABuilt 1969 · S/N 28R-35212N9492NKnaust Kurt · Baldwinsville, NYBuilt 1969 · S/N 28R-35213
Back to AD 81-11-02 R1