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.

N4920LLvc Air LLC · Allen, TXBuilt 1967 · S/N 28-4285N4921LBarrett Howard L · Austinville, VABuilt 1967 · S/N 28-4286N4922LSpanjer William H · Pine Bush, NYBuilt 1967 · S/N 28-4288N4923LDevrnja Aero LLC · Louisville, TNBuilt 1967 · S/N 28-4289N4926LRedden John V · Mooresville, NCBuilt 1967 · S/N 28-4293N4927LProfessional Plastic Solutions LLC · Irving, TXBuilt 1967 · S/N 28-4294N4928LTwo8lima Llp · Bryan, OHBuilt 1967 · S/N 28-4295N4929LMaak Air LLC · Wahoo, NEBuilt 1967 · S/N 28-4296N492BNTurner Harvey Jr · Raleigh, NCBuilt 1967 · S/N 28-4167N492FLMcknight Anna Mae · Vernon, TXBuilt 1971 · S/N 28-7125306N4930LG Salisbury & Associates Inc · Prescott, AZBuilt 1967 · S/N 28-4297N4931LThrust Spear Of Tampa LLC · Tampa, FLBuilt 1967 · S/N 28-4299N4933LSouthall Charles B · Amelia, OHS/N 28-4301N4934LFlyboys LLC · Orange, VABuilt 1967 · S/N 28-4302N4935LCurnutt Aviation LLC · Fort Stockton, TXBuilt 1968 · S/N 28-5127N4936LBluse James · Bethlehem, GABuilt 1967 · S/N 28-4304N4939LNorcross Tracy D · Saint Joseph, MOBuilt 1967 · S/N 28-4309N493FLPalmenteri Louis J · Rhome, TXS/N 28-7125308N4940LDrown William K · Columbus, OHS/N 28-4310N4944LWilson Zane D · Fairbanks, AKBuilt 1967 · S/N 28-4313N4945LAlahmadi Hussein I · Avon, CTS/N 28-4314N4946LAndrews University · Berrien Springs, MIBuilt 1967 · S/N 28-4315N4946TElite Fleet Jacksonville LLC · Jacksonville, FLS/N 28-7225286N4947LAmoth Dallas V · Bonners Ferry, IDBuilt 1967 · S/N 28-4316N4948LGlinsky Gabriel O · Surf City, NCS/N 28-4317N4949LLim Young Keun · Carthage, MOBuilt 1967 · S/N 28-4318N494FLWilliams Mark J · Ojai, CABuilt 1971 · S/N 28-7125309N4950LDesimone Joseph L · Castle Rock, COBuilt 1967 · S/N 28-4320N4951LMetcalf Linda G · Amarillo, TXBuilt 1967 · S/N 28-4321N4952LWalters Larry C · Wasilla, AKS/N 28-4323N4953FQuinney William B · Kill Devil Hills, NCS/N 28-7725037N4953LSale Reported · Harrells, NCSale reportedBuilt 1967 · S/N 28-4324N4954LSavoie John P · Jal, NMBuilt 1967 · S/N 28-4325N4955LDakan John M · Hemet, CABuilt 1967 · S/N 28-4326N4957LButler Cole A · Snowflake, AZBuilt 1967 · S/N 28-4328N4958LOgren James A · De Smet, SDBuilt 1968 · S/N 28-5007N4959LFly Cht LLC · Chillicothe, MOBuilt 1967 · S/N 28-4330N495FLUrban Thomas L · Glencoe, MNBuilt 1971 · S/N 28-7125310N4960LWynn Wora A · Scottsdale, AZBuilt 1967 · S/N 28-4331N4961LKral Aircraft LLC · Ocala, FLBuilt 1967 · S/N 28-4332N4961THatami-Nezhad Jamshid · Encino, CABuilt 1972 · S/N 28-7225289N4963LBakk Dale A · Nikiski, AKBuilt 1967 · S/N 28-4334N4964LMcallister Robert G · Santee, CABuilt 1967 · S/N 28-4335N4965LCurrent Jim · Hannibal, MOS/N 28-4336N4966LNelson Osea C · Sheridan, WYBuilt 1967 · S/N 28-4337N4968LSchoolcraft William F · Middletown, OHBuilt 1967 · S/N 28-4339N4969LLubnau Berdy G · New Braunfels, TXBuilt 1967 · S/N 28-4341N4970LAzflyers LLC · Gilbert, AZBuilt 1967 · S/N 28-4344N4971LNathanson David · Los Angeles, CAS/N 28-4345N4971TRegistered aircraftBuilt 1972 · S/N 28-7225295
Back to AD 96-10-01 R1