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.

N4716LLong Steven M · Baton Rouge, LABuilt 1967 · S/N 28-4036N4718LSnt Aviation LLC · Laurel, MSBuilt 1967 · S/N 28-4038N4719LMinderman David J · Westlake, OHBuilt 1967 · S/N 28-4039N4721LLee Christopher S Sr · Quinton, VABuilt 1967 · S/N 28-4043N4727LTeton Anesthesia Ltd · Batesville, ARS/N 28-4051N4729LCollinson Roger A · Concord, NCBuilt 1967 · S/N 28-4053N4730LMorris Robert W Jr · Owasso, OKS/N 28-4055N4732LRaven Gang Flyers Corp · Wilmington, DEBuilt 1967 · S/N 28-4058N4734LForsgren Lyle M · Oshkosh, WIBuilt 1967 · S/N 28-4060N4735LGunter David R II · Lavonia, GABuilt 1967 · S/N 28-4061N4736LRogue Aviators LLC · Ashland, ORS/N 28-4062N4738LRight Side Up LLC · Salisbury, NCBuilt 1967 · S/N 28-4064N4739LOracle Aviation LLC · Omaha, NEBuilt 1967 · S/N 28-4066N4741LMallard Scott R · Capshaw, ALBuilt 1967 · S/N 28-4068N4742LGautier Thomas · Cleveland, OHBuilt 1967 · S/N 28-4069N4743LRegistered aircraftBuilt 1967 · S/N 28-4070N4744LSeniura Jerry W · Millington, MIBuilt 1967 · S/N 28-4071N4745LFlying Ts LLC · Royal Oak, MDBuilt 1967 · S/N 28-4072N4746LJrc Aviation Inc · Plano, TXBuilt 1967 · S/N 28-4074N4747LHiner Hillard D Jr · Angola, INBuilt 1967 · S/N 28-4075N4748LSpectrum Aviation LLC · Mesa, AZBuilt 1967 · S/N 28-4076N4749LSamaniego Jay Emmanuel · Eldorado, TXS/N 28-4077N474DJRegistered aircraftBuilt 1974 · S/N 28-7405198N474FLDavis Donald W · Hendersonville, TNBuilt 1971 · S/N 28-7125279N4751LBoyd Aero Services LLC · Claremore, OKS/N 28-4080N4752LR & T Aviation Inc · White Lake, NCBuilt 1967 · S/N 28-4082N4753LLake Almanor Aviation LLC · Chester, CABuilt 1967 · S/N 28-4083N4755LBarnes John R · Waka, TXS/N 28-4085N4756LJones Tyler J · Williamsburg, KYBuilt 1967 · S/N 28-4086N4757LMil2atp Inc · Pikeville, NCBuilt 1967 · S/N 28-4087N4758FPhastar Corp · Cleveland, OHS/N 28-7725028N4758LStouffer Michael L · De Soto, ILBuilt 1968 · S/N 28-4088N4759LPc 180 LLC · Lincoln, NEBuilt 1967 · S/N 28-4090N4759TPasricha Sarosh K · Swedesboro, NJBuilt 1972 · S/N 28-7205195N4760LSouthern Utah University · Cedar City, UTBuilt 1967 · S/N 28-4091N4762LRegistered aircraftBuilt 1967 · S/N 28-4093N4763LRobson Kevin J · Carrabelle, FLBuilt 1967 · S/N 28-4094N4765LClements Corbin B · Snyder, TXBuilt 1967 · S/N 28-4096N4769LTurn 2 Aviation LLC · Bloomsburg, PABuilt 1967 · S/N 28-4101N476FLHawkins Rebecca · Sandpoint, IDS/N 28-7125281N4770LIdol Joshua N · Boone, NCBuilt 1967 · S/N 28-4102N4771LHenderson Brian K · Redding, CABuilt 1967 · S/N 28-4103N4772LValiair Lc Trustee · Casper, WYBuilt 1967 · S/N 28-4104N4775LWadkins Chris H · Plummer, IDBuilt 1967 · S/N 28-4109N4776LHitt John C · Plano, TXBuilt 1967 · S/N 28-4110N4777LRoss Charles B · Anchorage, AKBuilt 1967 · S/N 28-4111N4778LGarrett Russell K · Hazen, NDS/N 28-4112N4780LLemon Kyle · Santa Ynez, CABuilt 1967 · S/N 28-4115N4781LPhillips James W · Lancaster, SCBuilt 1967 · S/N 28-4116N4782TJordan Kevin · Brookline, NHBuilt 1972 · S/N 28-7225204
Back to AD 96-10-01 R1