OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,138

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.

N1566JGjestson Derek · Brooklyn Park, MNS/N 28-23971N15671On Final Aviation LLC · Brookland, ARS/N 28-7325131N15675Airfleet Solutions LLC · Newark, DEBuilt 1972 · S/N 28-7325134N15677Magneto Flyers LLC · Alexandria, OHBuilt 1972 · S/N 28-7305114N15678Pg Farms Inc · Shelton, NEBuilt 1972 · S/N 28-7305116N1567JBerry'S Air Freight Inc · West Columbia, SCBuilt 1967 · S/N 28-23972N15682Bold Pipe Dream LLC · Los Angeles, CABuilt 1972 · S/N 28-7325135N15694Registered aircraftBuilt 1972 · S/N 28-7305119N15695Baldwin Lydia H · Fort Collins, COBuilt 1972 · S/N 28-7305120N15701Miranowski Dean A · Goddard, KSBuilt 1972 · S/N 28-7325142N15703Schubert Brothers Aviation Inc · Canandaigua, NYBuilt 1972 · S/N 28-7305125N15713Gwf Management LLC · Lansing, MIS/N 28-7305126N15715Pilotronics LLC · Bay Village, OHBuilt 1972 · S/N 28-7325144N15716Otero Jose L · Harker Heights, TXBuilt 1972 · S/N 28-7325145N1571JAcadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1967 · S/N 28-23977N15726Aircraft Repair Center · Lake Worth, FLBuilt 1972 · S/N 28-7325147N15731Parsons Allen L · Marriottsville, MDBuilt 1972 · S/N 28-7305129N15734Wayland Flyboys LLC · Wayland, IABuilt 1972 · S/N 28-7305131N15739Flymart Inc · Hastings, FLS/N 28-7305132N15741Jps Flight School LLC · Salem, ORBuilt 1972 · S/N 28-7305134N15753Bischoff Daniel C · Camano Island, WABuilt 1972 · S/N 28-7325152N15755Fitzgerald Lee M · High Springs, FLBuilt 1973 · S/N 28-7325154N15757Dickinson Ross · Tilden, TXBuilt 1972 · S/N 28-7305137N15759Williams Sean Aaron · Whiteland, INBuilt 1973 · S/N 28-7325155N15760Been Flyin LLC · Colchester, CTBuilt 1972 · S/N 28-7325157N15762Carlevaro Bruce C · Edmond, OKBuilt 1972 · S/N 28-7305140N15763First Pryority Bank · Pryor, OKBuilt 1972 · S/N 28-7305141N15768Khleb Hub LLC · Palm Coast, FLBuilt 1973 · S/N 28-7325156N1576JInspire Aviation LLC · Magnolia, TXBuilt 1967 · S/N 28-23982N15770Collett Palmer · Frankfort, KYBuilt 1972 · S/N 28-7325159N15782Crane Austin · Redlands, CAS/N 28-7305144N15783Pretorius Anthony · Easley, SCBuilt 1972 · S/N 28-7305145N1579JTornow Saxon Michael · Highland, UTS/N 28-23987N15800Somd Aircraft Rentals And Instruction LLC · Leonardtown, MDBuilt 1972 · S/N 28-7325167N15802Farias Wellington N · Hollis, NHS/N 28-7305146N15804Lima Juliet LLC · Pearcy, ARBuilt 1972 · S/N 28-7305150N15807Timmons Nathan M · Sarepta, LABuilt 1972 · S/N 28-7325168N15808Dudek Henry · Clinton Township, MIBuilt 1972 · S/N 28-7325169N158124 Bachelors LLC · Chesaning, MIS/N 28-7305152N15819Brewer Les · Magna, UTS/N 28-7325170N1581JDarling Steven M · Decatur, INS/N 28-23989N15822Keys Daniel A · Irvine, CABuilt 1972 · S/N 28-7325172N15824Pacific Union College · Angwin, CABuilt 1972 · S/N 28-7305156N15825Jem Machine Inc · Grangeville, IDBuilt 1972 · S/N 28-7305157N15842Reynolds Larry J · Rhome, TXBuilt 1972 · S/N 28-7325177N1584JLake Kenneth M · Manchester, MOBuilt 1967 · S/N 28-23993N15850Aviation East Inc · Mount Pleasant, SCBuilt 1972 · S/N 28-7305164N15851Eakle Ivan · Sacramento, CABuilt 1972 · S/N 28-7325190N15858T T T Inc · Georgetown, PABuilt 1972 · S/N 28-7325180N1585JAnderson Aviation LLC · Eatonville, WABuilt 1967 · S/N 28-23994
Back to AD 96-10-01 R1