OpenAirDocs.org
AD 96-12-03 R2

Registered aircraft · 164

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-12-03-R2')
    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-12-03-R2')
  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.

N603SBHats Off Aviation LLC · Draper, UTS/N 5035N6076JAtlantic Resources Of Miami Inc · Deland, FLS/N 5235N6079YWaller Stephen B · Fairhope, ALBuilt 1992 · S/N 5239N6081UHutchings Zachary A · Clewiston, FLBuilt 1992 · S/N 5267N60823Green Ethan H · San Antonio, TXBuilt 1992 · S/N 5269N60827Buergel Sandra J · East Aurora, NYBuilt 1993 · S/N 5280N6082UWifferdill Inc · Palm Bay, FLBuilt 1991 · S/N 5215N6087EGuletsky Stephen W · Goshen, CTBuilt 1994 · S/N 5312N6089UPlane Fun Inc Tr Trustee · Snellville, GABuilt 1994 · S/N 5311N60JLLeluc Jerome · Fort Worth, TXBuilt 1985 · S/N 5086N61PSPitts Rock And Roll Inc Trustee · Wilmington, DEBuilt 1991 · S/N 5230N625RFTallarita Peter D · Webster, MNBuilt 1983 · S/N 1018N62PSRegistration Pending · Wallace, CARegistration pendingBuilt 1993 · S/N 5291N65PSEastern Stearman Inc Trustee · Leesburg, VABuilt 1993 · S/N 5275N666BMPlane Fun Inc Tr Trustee · Snellville, GABuilt 1991 · S/N 1057N697RBAerospace Trust Management LLC Trustee · Wilmington, DES/N 1042N6RYTracy David B · West Haven, UTS/N 5264N6WChase Roy M · Limington, MEBuilt 1970 · S/N 29PN711SFFlying L Aircraft Inc · Fort Denaud, FLBuilt 1997 · S/N 5351N714HRegistered aircraftS/N 15PN719APPeros Dino · Pipersville, PABuilt 1981 · S/N 2245N71AH & J Airplane LLC · Wilmington, DEBuilt 1992 · S/N 5254N71RZSmith John J · Middlefield, CTBuilt 1996 · S/N 5349N727PSGardner Timothy J · Gardnerville, NVBuilt 1996 · S/N 5343N731FLLibrino Filippo · Tomball, TXBuilt 2007 · S/N 1061N73CFFredette Catherine · Beaverton, ORS/N 2215N742MADinning Gregory J · Shirley, MABuilt 1982 · S/N 1005N74LSAerodyne Industires Corp · Elburn, ILS/N 5288N787PDDougherty Paul · Bethel, PAS/N 5318N79AVRegistered aircraftBuilt 1986 · S/N 5114N79DLattanzi James A · Atco, NJBuilt 1992 · S/N 5260N7EHHalimi Timothy · Bell, CABuilt 1994 · S/N 5314N7XXAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1991 · S/N 5221N808JPPruzek Joshua W · West Linn, ORBuilt 1993 · S/N 5278N80ASAlpha Sierra LLC · Simi Valley, CABuilt 1992 · S/N 5244N80WSMh Aviation LLC · Foster City, CABuilt 1994 · S/N 5304N811RMForero Christopher · Mercerville, NJBuilt 1995 · S/N 5332N812BLLett Robert W · Dallas, TXBuilt 1997 · S/N 5356N822PGottschall Kenneth Lee III · Santa Paula, CAS/N 5341N846Davis Hedley C · Middletown, DEBuilt 1992 · S/N 5257N84PSValiair Lc Trustee · Casper, WYBuilt 1983 · S/N 5031N85FZZeller Francis J · Rosamond, CAS/N 1032N8671Plane Fun Inc Tr Trustee · Snellville, GAS/N 25PN87WYCarter Mark E · Salem, VABuilt 1986 · S/N 5111N88WSChamberlain Donald R · Simsbury, CTBuilt 1974 · S/N 1N912STAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1994 · S/N 5298N913STRuff Randall N · Bay City, MIBuilt 1992 · S/N 5258N916Kyer Barry Patrick · Honey Grove, TXBuilt 1994 · S/N 5316N91THEmpyrean Air Corp · Denver, COS/N 1059N922PBillester Stephen E M · Parker, COBuilt 1974 · S/N 271H
Back to AD 96-12-03 R2