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.

N1219AFeltman Joshua C · Kenai, AKS/N 18-834N1219USouth Bay Flight Training Center · Carolina, PRBuilt 1976 · S/N 17266916N121AWhidby Richard L · Aynor, SCBuilt 1992 · S/N 2045N121AVPreece William F · Cheshire, CTBuilt 1984 · S/N 28-8490078N121BBFearon Terrence J · Whitehouse Station, NJBuilt 1963 · S/N 18-7908N121BPFord Kevin L · Peachtree City, GABuilt 1968 · S/N 015N121CRMaxson Lee V · Mesa, AZS/N 418N121DSGarvison Paul L · Hillsville, VABuilt 1995 · S/N 22373N121ECN121ecfllyers LLC · South Jordan, UTBuilt 1967 · S/N 17700036N121ERFreedom Aviation LLC · Dover, DES/N 1510N121ESWell Bilt Industries USA LLC · Ocala, FLBuilt 1971 · S/N 28-7125383N121FTBowman William K · Raleigh, NCBuilt 1982 · S/N 28-8216191N121GBAviation Academy LLC · Wichita, KSBuilt 1968 · S/N 17257308N121HHTimm Robert S · Minneapolis, MNBuilt 1992 · S/N 1209N121JAAlbers Edward J Jr · Oviedo, FLBuilt 1991 · S/N 121N121JZZack Jay T · Cloquet, MNBuilt 2002 · S/N 0121N121KAAir Ally Asset Management LLC · Chisago City, MNS/N 17263836N121LCJolisea Wings LLC · Palm Bay, FLBuilt 2003 · S/N 21161N121MDBaggarly Michael · Newnan, GABuilt 1969 · S/N 28-25613N121MNNielsen Mark C · Green Bay, WIBuilt 1997 · S/N MN-01N121MSDarcy Aviation LLC · Danbury, CTBuilt 1978 · S/N 17271893N121PGGinter Jon A · Marlton, NJBuilt 2005 · S/N 70731N121VKOcala Aviation Services Inc · Ocala, FLBuilt 1984 · S/N 17276101N121WPRoy Frank W · Millinocket, MES/N 1382N12200Dunahoo Steven W · Cleveland, GABuilt 1973 · S/N 17261880N12202Hudson Kent O · Anchorage, AKBuilt 1972 · S/N 339-72N12207Faris Isaac · Swartz Creek, MIBuilt 1972 · S/N 34272N12209Melendez Jesus · North Miami, FLS/N 17261881N1220BWash Steven M · Austin, TXBuilt 1957 · S/N 23-1161N1220HScroggs Jack F · Anchorage, AKBuilt 1948 · S/N 15AC-232N1220UParinger Glenn R · Nashotah, WIBuilt 1993 · S/N 0092N1220XBuilding Enclosure Institute Inc · Hallandale Beach, FLBuilt 1963 · S/N 191N1220ZColumbus State Community College · Columbus, OHBuilt 1959 · S/N 24-800N12210Exclusive Motors Inc · Grand Prairie, TXBuilt 1973 · S/N 17261882N12211Miller Todd B · Wayne, ILBuilt 1973 · S/N 17261883N12212Wilson Donovan F · Friday Harbor, WABuilt 1973 · S/N 17261884N12213Top Flight Aviation Inc · Corona, CABuilt 1973 · S/N 17261885N12215Cm3 LLC · North Las Vegas, NVBuilt 1973 · S/N 17261887N1221AGerbi Charles R Trustee · Auke Bay, AKBuilt 1951 · S/N 18-832N1221LNewman James B · Albany, ORBuilt 1991 · S/N 10072N1221TOakley Scott S · Essex, MDBuilt 1970 · S/N 17259334N1221UJ Linn Aviation Inc · Quinlan, TXBuilt 1976 · S/N 17266918N12229Zapsky Richard M Jr · Houtzdale, PABuilt 1973 · S/N 17261892N1222ADawley Creek Ranch Nv LLC · Ruby Valley, NVBuilt 1951 · S/N 18-837N1222LBoland Charles R · Blairsville, GABuilt 1969 · S/N 17258385N12232S C Skyhawks Inc · Columbia, SCBuilt 1973 · S/N 17261895N12234Amelia Reid Aviation LLC · San Jose, CABuilt 1973 · S/N 17261896N12236Wolak Filip O · New York, NYBuilt 1973 · S/N 17261898N12239Gables Christopher A · Riverside, CABuilt 1973 · S/N 17261900N1223TBeech Club LLC · Meadville, PABuilt 1980 · S/N M-2272
Back to AD 79-10-03 R2