OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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.

N4895GWilson Forest B · Hollister, CABuilt 1979 · S/N 17273442N4895VEbrite Richard P · Long Beach, MSBuilt 1980 · S/N 172RG0410N48966Kapellair LLC · Wickenburg, AZBuilt 1943 · S/N 230N4896GGecha Richard Mike · Florence, VTBuilt 1979 · S/N 17273443N4896LMike Delta Kilo LLC · Bentonville, ARBuilt 1967 · S/N 28-4263N4896MSmtm Holdings Inc · Wilmington, DEBuilt 1981 · S/N 17274294N4896TVosler Dean S · Bay City, MIBuilt 1972 · S/N 28-7225233N4896VSouth Aero LLC · Albuquerque, NMBuilt 1980 · S/N 172RG0411N4897ESig Flights LLC · Hickory, NCBuilt 1978 · S/N 17271674N4897FGnl Aviation LLC · Weatherford, OKFirst renewal noticeBuilt 1976 · S/N 28-7790071N4897GWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 17273444N4898FLima-001 LLC · Muscatine, IABuilt 1979 · S/N 17273097N4899GJf Property Leasing Inc · Port Orchard, WAS/N 17273446N4899LSweat Larry D · Meridian, IDBuilt 1967 · S/N 28-4266N489ACKuza Flyers LLC · Rock Hill, SCBuilt 1999 · S/N 413-98N489BCAviation Services Inc · Barre, VTBuilt 1974 · S/N 17264443N489ERMenefee Scott A · Los Banos, CABuilt 1978 · S/N 17272083N489JOrr Matthew W · Kirkland, WAS/N 265N489JEChambless Mardre F II · Panama City, FLBuilt 2004 · S/N 90508N489PWsi Southwest Inc · Cliff, NMBuilt 1965 · S/N 28-21083N489TJUnknown Media LLC · Cape Canaveral, FLS/N 3024N48ARGacey Inc Trustee · Wilmington, DEBuilt 1966 · S/N 30-1328N48BGWhitfill Mark J · Crockett, TXBuilt 1978 · S/N 17271064N48CEEssential Aviation Llcregistered · Hickory, KYBuilt 1958 · S/N TD-163N48CLSharp Wade L · Asheville, NCS/N 21184N48DXSomers Andrew · El Paso, TXBuilt 2003 · S/N 386N48ERChess Group LLC · Minden, LABuilt 1978 · S/N AA5B0906N48GHYellowstone Aviation Inc · Jackson, WYBuilt 1999 · S/N 2049N48HYStruble Anne D · Springville, UTBuilt 2002 · S/N 2196N48JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1975 · S/N 17265312N48JJTotten James C · Newark, NJBuilt 1979 · S/N GA7-0110N48JKKeahey Britt · Saint Joseph, LABuilt 1972 · S/N 17260693N48KBRydberg Lawrence · Albuquerque, NMBuilt 1998 · S/N 26N48KSHolcomb Garry M · Point, TXS/N PTS101N48MMDierks Herman D · Round Rock, TXBuilt 1967 · S/N RCM67N48PKWoodward Daniel S · Springville, UTS/N 5382N48PRBadrow Allan R · Warrenton, VABuilt 2002 · S/N 2843533N48RPClark Mitchell J · Parker, COBuilt 1978 · S/N 658-HN48SSiragusa Pamela L · Cypress, TXBuilt 1958 · S/N TD-40N48SJJohnston Stephen P · Hawley, MNBuilt 1948 · S/N 1466N48TDFoster Aviation LLC · Missoula, MTBuilt 1997 · S/N 123297N48WLAtkinson Matthew D · Theodore, ALBuilt 1978 · S/N AA5B0892N4902FFlying Vikings Inc · Hayward, CABuilt 1979 · S/N 17273099N4902LObrien William M · Aptos, CABuilt 1967 · S/N 28-4269N4903LPlane Crazy Aviation LLC · Hollywood, SCBuilt 1967 · S/N 28-4270N4904GC & W Aviation LLC · Trumbull, CTBuilt 1979 · S/N 17273451N4904LSchmick David D · Sturgis, MIBuilt 1967 · S/N 28-4271N4906LRitter Steven L · Harlingen, TXBuilt 1967 · S/N 28-4274N4907LSmooth Landin Inc · Melville, NYBuilt 1967 · S/N 28-4222N4907ZChristie Ian A H · Limon, COS/N 22-8492
Back to AD 79-10-03 R2