OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,139

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:96-10-01-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:96-10-01-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.

N6796JArcila Daniel · Lakeland, FLBuilt 1968 · S/N 28-24526N6798JDead Frog LLC · Miles City, MTBuilt 1968 · S/N 28-24529N6798WRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1965 · S/N 28-20932N67DBD&R LLC · Emory, TXBuilt 1974 · S/N 28-7505096N67DLMcarthur Narik D · Mammoth Lakes, CAS/N 28-25605N67KTTatsumi Kurtis · Sheldon, IABuilt 1963 · S/N 28-1245N67PLSky Point Aviation LLC · Sugar Land, TXBuilt 1967 · S/N 28-22800N67SKMaloy Bryan K · Georgetown, TXS/N 28-4649N67WACapital District Pilots LLC · Slingerlands, NYBuilt 1971 · S/N 28-7125267N6801WLaw Lewis L · Moncks Corner, SCBuilt 1965 · S/N 28-20935N6803WWallace David A · Hancock, NHBuilt 1965 · S/N 28-20938N6806WWings Up LLC · Saint Augustine, FLBuilt 1965 · S/N 28-20941N6808WClear Blue Aviation LLC · Melbourne, FLBuilt 1965 · S/N 28-20944N680CDFly Mnt LLC · Glenview, ILBuilt 1973 · S/N 28-7325158N680FLSchrimpf Robert · Batesville, INBuilt 1971 · S/N 28-7125611N6811WKlaerner Donald John · Fredericksburg, TXBuilt 1965 · S/N 28-20947N6813WRotor And Wing LLC · Tioga, NDBuilt 1965 · S/N 28-20949N6814JTavzel Aviation LLC · Portland, INBuilt 1976 · S/N 28-7625242N6816WCabala Dennis G · Bay City, MIBuilt 1965 · S/N 28-20954N6817WRahz Robert D · Kirtland, OHBuilt 1965 · S/N 28-20955N6819WMikletich Christian E · Springfield, KYS/N 28-20957N6822WAjf Enterprises LLC · Des Moines, IAS/N 28-20960N6823WThomas Kevin A · Selbyville, DEBuilt 1965 · S/N 28-20961N6824JMorrison Justin Gregory · Houston, TXBuilt 1976 · S/N 28-7625243N6824WRoberts John R Jr · Homestead, FLBuilt 1965 · S/N 28-20962N6826WMartinak Charles J · Rehrersburg, PABuilt 1965 · S/N 28-20966N6827WShort Final Aviation LLC · Branson, MOBuilt 1965 · S/N 28-20967N6828WOleary David L · Framingham, MABuilt 1965 · S/N 28-20968N6832WLitchfield Bobby Lee · Claremont, CAS/N 28-20973N6833CTexins Flying Club · Mckinney, TXBuilt 1965 · S/N 28-3024N6833JHumphries Aviation LLC · Maysville, KYBuilt 1976 · S/N 28-7625244N6834WFlores Lindenfelser Armando · Apache Junction, AZBuilt 1965 · S/N 28-20975N683FLPuhalla Matthew C · Shelton, NES/N 28-7125616N6841WBoehm Darrell · Safford, AZBuilt 1965 · S/N 28-20984N6842JOracle Aviation LLC · Omaha, NEBuilt 1976 · S/N 28-7625245N6843WRhodes Michael J · Fresno, CABuilt 1965 · S/N 28-20986N684FLRegistration Pending · Odenton, MDRegistration pendingBuilt 1971 · S/N 28-7125618N684RAArendale Richard O · Hattiesburg, MSBuilt 1968 · S/N 28-4695N6850WDixon Holly R · Denton, NEBuilt 1965 · S/N 28-21005N6852WJurol Aviation Limited · Norwalk, OHBuilt 1965 · S/N 28-21008N6854WKimberl John M · Milton, FLBuilt 1965 · S/N 28-21010N6855XHartsock William Kent · Morristown, TNBuilt 1968 · S/N 28-4642N6856WRogers Kevin Shane · Highland Village, TXBuilt 1965 · S/N 28-21012N6857WN6857w Inc · Palos Heights, ILBuilt 1965 · S/N 28-21013N6859JDobberfuhl Roy · Cedarburg, WIBuilt 1976 · S/N 28-7625247N685FLDadson Tach LLC · Mesa, AZBuilt 1971 · S/N 28-7125619N6861WLoffeimancher Richard P · Eastvale, CABuilt 1965 · S/N 28-21017N6862WFly Dynasty Corp · Ocala, FLBuilt 1965 · S/N 28-21018N6863WThrust Vector LLC · Austin, TXFirst renewal noticeBuilt 1965 · S/N 28-21019N6865WGraves William · Highlands, TXBuilt 1965 · S/N 28-21021
Back to AD 96-10-01 R1