OpenAirDocs.org
AD 96-12-03 R1

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-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-12-03-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.

N104MJLift Drag Aviation LLC · El Cajon, CAS/N 1036N105JPPittman Discover Flight LLC · Oshkosh, WIS/N 5150N110PSHartvigsen Thomas E · Winchester, TNBuilt 1996 · S/N 5335N1191Vmc Aviation Inc · Upland, CAS/N 5284N11ETGeygan Thomas J · Cincinnati, OHBuilt 1970 · S/N EJ9-13-23TN11NInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N 1051N12QWAll Aviation LLC · Tucson, AZBuilt 1984 · S/N 5053N1326KPlane Fun Inc Tr Trustee · Snellville, GABuilt 1995 · S/N 5310N13KTButler Bryan C · Brenham, TXBuilt 1992 · S/N 5250N14LPTherp Todd J · Rigby, IDBuilt 1991 · S/N 5217N153GMFly High Aviation LLC · Melrose Park, ILBuilt 1992 · S/N 5266N15WAG Force Aerobatics LLC · Eugene, ORBuilt 1992 · S/N 5247N161JHAllison Daniel S Trustee · Jenner, CABuilt 1991 · S/N 5232N161PSBond Robert E · Knoxville, TNBuilt 1996 · S/N 5339N161TCAkrotown USA LLC · Tualatin, ORS/N 5357N1643Elias Bernard J · Hampton, GABuilt 1982 · S/N 3008N1651NHartley John R · Bozeman, MTBuilt 1995 · S/N 5331N169DMMost Toys Wins LLC · Joliet, ILBuilt 1995 · S/N 5330N187PSMorrissey John C Col · Lees Summit, MOBuilt 1979 · S/N 2187N197TJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1992 · S/N 5237N19HCVista I Inc · Smithville, OHBuilt 1982 · S/N 2266N1ANConnelly Robert I · Blowing Rock, NCS/N 5079N1PWWelkin Aero Inc · Garden Plain, KSBuilt 1979 · S/N 1004N203MCMac IV Aeroworks LLC · St Petersburg, FLBuilt 1984 · S/N 5036N224TJJennings Herschel Todd · Stone Mountain, GABuilt 1993 · S/N 5283N22XPEverything Pitts LLC · Queen Creek, AZS/N 002N245JHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1993 · S/N 5290N24FFHiemenz Thomas S · Westfield, INBuilt 1992 · S/N 5265N252PSFields Joseph H · Placerville, CABuilt 1999 · S/N 5334N255PSSamani David L · Lincoln, NEBuilt 1996 · S/N 5336N25CHPlanes Of Fame Air Museum · Chino, CABuilt 1986 · S/N 5106N25TCWoolslayer Homer J · Tulsa, OKBuilt 1991 · S/N 5222N260CKSierra Lima LLC · Missoula, MTBuilt 1991 · S/N 5225N260EFGiering Margaret J · Southampton, NYS/N 5078N260EJBrown Daniel A · Gettysburg, PAS/N 5043N260KAAntcliff Wayne E · Newport, WABuilt 1984 · S/N 5042N260LSSuter Lloyd Eugene · Apalachin, NYBuilt 1993 · S/N 5295N260MJStoked Aero LLC · Camas, WABuilt 1984 · S/N 5045N260PAThompson Benjamin K · Nevada, TXS/N 5219N260PGTregeagle Richard D · Sandy, UTBuilt 1991 · S/N 5223N260PRPlane Enterprises Inc · Martin, TNBuilt 1991 · S/N 5231N260PSBulldawg LLC · Byers, COBuilt 1991 · S/N 5227N260PWDuvall Garrett S · New Providence, PAS/N 5041N262PDGritter Richard J · Catlett, VABuilt 1991 · S/N 01N2788Tippit Larry Jack · Grand Prairie, TXBuilt 1970 · S/N 30PN287PJWaterbury Craig A · El Paso, TXBuilt 1994 · S/N 5287N28PBIpme Management Corp · Jefferson, GABuilt 1974 · S/N 2069N291PSInternational Air Services Inc Trustee · Carson City, NVBuilt 1995 · S/N 5322N29KTManary Norman L · Rialto, CAS/N 2082N29RGHappy Raptor Flying Club LLC · Fort Lupton, COBuilt 1991 · S/N 5229
Back to AD 96-12-03 R1