OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,401

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:79-10-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:79-10-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.

N1295AJenski Kobie · Sutton, AKBuilt 1951 · S/N 18-1098N1295TLutz Brian · Carmel, INBuilt 1972 · S/N 28-7205278N1295UWolff Timothy W Trustee · Monroe, WIBuilt 1976 · S/N 17266989N12960Hennessee Timothy H · New Braunfels, TXBuilt 1973 · S/N 17262405N12968Rtd Aviation LLC · Hillsborough, NJBuilt 1973 · S/N 17262413N1296UKirk Claire Y · Huntington Beach, CABuilt 1976 · S/N 17266990N12973Mor Aviation LLC · Gaithersburg, MDBuilt 1973 · S/N 17262418N12974Forest Ken W · Wales, NDBuilt 1972 · S/N 17262419N12976Wanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1973 · S/N 17262421N1297FJprg Aviation Inc · Orlando, FLBuilt 1979 · S/N 17272990N12983Haman Aviation Services LLC · Nokomis, FLBuilt 1973 · S/N 17262427N12984Go Fly Az LLC · Gilbert, AZBuilt 1975 · S/N 17702394N12985Alamakee Flyers · Waukon, IABuilt 1973 · S/N 17262429N12991Usda Forest Service Fepp · Columbia, SCBuilt 1973 · S/N 17262432N12997Wausau Flying Service Inc · Wausau, WIS/N 17262437N1299URice Melvin G · Bridgeport, TXBuilt 1976 · S/N 17266993N1299XMunoz David · Corona, CAS/N 2680N129CCChilds David E · Amber, OKBuilt 2002 · S/N 9951CCN129DDDruckenbrodt Donald D · Fredericksburg, TXS/N 1393N129FRWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 17275338N129MAAttwood Nicholas John · Ashburn, VAS/N 2890219N129MSWinging It LLC · Kalispell, MTBuilt 2004 · S/N 3712N129MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496172N129SAero Quest LLC · Olive Branch, MSBuilt 1974 · S/N 17263118N129SLLee Aero LLC · Wichita, KSBuilt 1979 · S/N 17273503N129SYDaigle Danny · Greenville, MEBuilt 1978 · S/N 17270741N129YEBuell Travis W · Harper, TXBuilt 2002 · S/N 3334N12ADAltizer John N · The Woodlands, TXBuilt 1994 · S/N JWA-2N12AKBurk Ross T · Casper, WYS/N 5695N12BJValentour Lance F · Naperville, ILBuilt 1974 · S/N 17264570N12BVRoberts William O · Lexington, VAS/N 0241N12DPKish Gary A · Montrose, MIBuilt 1975 · S/N 1212DN12DSBuckbee Robert E · College Station, TXBuilt 1984 · S/N 27N12ERPropelling The Gospel Missions Inc · Standish, MEBuilt 1976 · S/N 28-7615099N12FMDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816439N12GANy Flying Tigers LLC · Ronkonkoma, NYBuilt 1977 · S/N AA5B0635N12GCNorman Ashton J · Zanesville, OHBuilt 2000 · S/N 2264N12GLHayden Debra J · Utica, KYBuilt 1995 · S/N JR-2N12GNNauta Gordon Wayne · Palmdale, CABuilt 1977 · S/N 112N12HHWilliams Jeffrey · Florence, ALBuilt 1989 · S/N 1688N12HRHarben Grover S III · Gainesville, GABuilt 1991 · S/N 1664N12HZBaldauf Ryan L · Spencerville, OHBuilt 1976 · S/N 17266707N12KBWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261915N12LGLapiair LLC · Vergennes, VTBuilt 1998 · S/N 20418N12LPBlewett John Thomas Jr · Springfield, GABuilt 1998 · S/N 21056CN12LTBaker William A · Lincolnton, NCBuilt 1972 · S/N 406N12LZConlon Joseph F · Gainesville, FLBuilt 2011 · S/N LZ001N12MJCruiseair Aviation Inc · Ramona, CABuilt 1972 · S/N 17261299N12MPMarcus Robert L · Dallas, TXBuilt 1963 · S/N 30-284N12PShalun Lukas A · Germantown, TNBuilt 1977 · S/N 001
Back to AD 79-10-03 R2