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.

N75093Turner Barry D II · Mccook, NEBuilt 1976 · S/N 28-7625198N75108Haga Christian K · Thousand Oaks, CABuilt 1976 · S/N 28-7625199N7510RNewton Hayden R · Charleston, MSS/N 28-22067N7512WNeblett Nathan · Fort Worth, TXBuilt 1965 · S/N 28-2908N75132Ferngulf Investments LLC · Loretto, MNBuilt 1976 · S/N 28-7625202N7513RAnderson Agency Inc · Racine, OHBuilt 1966 · S/N 28-22070N75146Gaiser Richard Mark · Berrien Springs, MIBuilt 1976 · S/N 28-7625203N7514RN7514r LLC · Las Vegas, NVBuilt 1966 · S/N 28-22071N75158Bowman Aviation LLC · Sebewaing, MIS/N 28-7625204N7515RRoquet Steven L · Fremont, IABuilt 1966 · S/N 28-22072N7515WAir Services Inc · Roca, NEBuilt 1963 · S/N 28-1431N7516WGreen Andrew · Hillsboro, TXBuilt 1963 · S/N 28-1432N7517410 Skies LLC · Rockport, TXBuilt 1976 · S/N 28-7625205N7517RGarringer William E · Pryor, OKBuilt 1966 · S/N 28-22074N75186Lessenberry James F · Leonard, MIBuilt 1976 · S/N 28-7625206N7518WNywhb Properties · Westhampton Beach, NYBuilt 1965 · S/N 28-2910N7520RN7396w LLC · Coeymans Hollow, NYBuilt 1966 · S/N 28-22078N75229Krump David J · Frederick, MDBuilt 1976 · S/N 28-7625208N7522RRed Baron Flying Club LLC · Oneida, NYBuilt 1966 · S/N 28-22080N7522WBaune Justin J · Hayden, IDS/N 28-1440N7523RFlorida Flyers Aviation LLC · Deltona, FLBuilt 1966 · S/N 28-22081N7523WHarned Anthony L · Port Saint Lucie, FLBuilt 1963 · S/N 28-1441N75248Leydsman Wayne · Provo, UTBuilt 1976 · S/N 28-7625209N7524RTiny Tin Aviation LLC · Groveland, FLBuilt 1966 · S/N 28-22082N7525RCallis Merle F · Lone Grove, OKBuilt 1966 · S/N 28-22083N75269Smart James Tim · Spurger, TXBuilt 1976 · S/N 28-7625210N7526WWensel Tyler · North Dinwiddie, VAS/N 28-1445N7527RTimms Paul E · Collierville, TNBuilt 1966 · S/N 28-22085N7527WKern David H · Mulberry, FLBuilt 1963 · S/N 28-1446N7528WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLBuilt 1963 · S/N 28-1449N7529RRoberts Chad Alexander · Lakeport, CABuilt 1966 · S/N 28-22087N7529WWitty Paul R · Delaware, OKBuilt 1963 · S/N 28-1450N7530WSohl Virginia · Farmingdale, NYBuilt 1963 · S/N 28-1452N7531WZmrzel David J · Port Saint Lucie, FLBuilt 1963 · S/N 28-1455N75327Karr Eric · Eau Claire, WIBuilt 1976 · S/N 28-7625214N7532WWirthlin Donald K · Sierra Vista, AZBuilt 1963 · S/N 28-1456N7534RVitrano Mike A · Culleoka, TNBuilt 1966 · S/N 28-22095N7535RDuval Daniel · Hohenwald, TNBuilt 1966 · S/N 28-22097N7537REconomou Brian P · Auburn, CABuilt 1966 · S/N 28-22099N7537WWindous Darin T · Spring Creek, NVBuilt 1963 · S/N 28-1470N75392G B Aviation Inc · Fort Lauerdale, FLNon-citizen corporation, flight hours not reportedBuilt 1976 · S/N 28-7625217N7539RShanahan Michael P · Cottage Grove, ORS/N 28-22101N7539WMccormick Michael J · Pocatello, IDBuilt 1963 · S/N 28-1472N7541RHoover Michael H · Baxter, TNBuilt 1966 · S/N 28-22103N7541WPiaquadio Dennis J · Newburgh, NYBuilt 1963 · S/N 28-1474N7542RCarr Scott A · Allen, NEBuilt 1966 · S/N 28-22104N7542WRegistration Pending · Rush City, MNRegistration pendingBuilt 1963 · S/N 28-1475N7543WHobbs Michael S · Midland, TXBuilt 1964 · S/N 28-1516N7544RReyes Aviation Inc · Middletown, DEBuilt 1966 · S/N 28-22339N7544WSchrag Douglas R · Pretty Prairie, KSBuilt 1963 · S/N 28-1477
Back to AD 96-10-01 R1