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.

N449AGKershner Jordan · Malcolm, NEBuilt 1967 · S/N 17700344N449DMMccord David B · Chico, CABuilt 1998 · S/N 001N449EWWilliams Ethan B Trustee · Wasilla, AKBuilt 2012 · S/N 001N449FAAlba Aviation Services Inc · Scottsdale, AZBuilt 2004 · S/N 3683N449PAChristiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 4496185N449PMMullenbach Michael R · Saint Ansgar, IABuilt 1999 · S/N 1466N449PSMid Atlanta Air Museum · Reading, PABuilt 1974 · S/N 12449N449RVRobinson Stewart · San Jacinto, CABuilt 1998 · S/N 20449N449WFGlenns Super Cub LLC · Fort Lauderdale, FLS/N 18-7773N44ADTice Logan Edward · Noblesville, INBuilt 1979 · S/N 123ADN44BLBoehr Greg J · Mc Cool Junction, NES/N 17256854N44CUAirstar Aviation LLC · Manawa, WIBuilt 1976 · S/N 17268037N44CZHeer James A · Lutz, FLBuilt 1988 · S/N 1N44DMGorge Winds Aviation Inc · Fairview, ORBuilt 1973 · S/N 17261488N44FDHildreth David M · Kennesaw, GABuilt 1956 · S/N 23-500N44KLStell Brandon A · Mechanicsville, VAS/N 803N44KPHargrave Margarite D · Seattle, WABuilt 1978 · S/N 172-70904N44LKCessna Skyhawk LLC · Parker, COFirst renewal noticeBuilt 1979 · S/N 17273400N44LRRouse Peter L · Parkville, MOBuilt 1996 · S/N 1N44LTLonderville Ross G · Stanwood, WABuilt 1984 · S/N 348N44PFVaayu Aviation LLC · Newark, CABuilt 1970 · S/N 28-26800N44PGSimon Jevon D · Buckley, WABuilt 1999 · S/N 2522-001N44PJSchaufenbuel Todd W · Imperial, NEBuilt 1992 · S/N 1209N44PPKnr Inc · Evanston, WYBuilt 1955 · S/N 22-2576N44PWWeber Peter III Trustee · Loudon, TNBuilt 1979 · S/N 28-8090147N44QGraf Erwin · Clayton, NCBuilt 1974 · S/N 446N44RTWinkelman Dan · Bethel, AKBuilt 1971 · S/N 18-8927N44STTakvorian Sevag · West New York, NJBuilt 1979 · S/N 17271609N44TCKinzie Hon K · Anchorage, AKBuilt 2002 · S/N 9941CCN44TDChristian Joe L · Naylor, GABuilt 1973 · S/N 1000N44VTNelson William R · Caldwell, IDBuilt 1994 · S/N 20121N44VVHampton Warrior II Inc · Shelter Island, NYBuilt 1980 · S/N 28-8116009N44WCWhite Eagle Investments LLC · San Jose, CABuilt 1995 · S/N 20242N44WKMaiden Robert M · Williamson, GABuilt 1983 · S/N 11144N44WLLitton Wade N · Townsend, MTBuilt 2026 · S/N 20510N44WMBloomfield Robert C · Anchorage, AKBuilt 1974 · S/N 18-7409095N44WZWild Blue Yonder LLC · Batavia, OHS/N 729N44XDDuffer David · Fallbrook, CABuilt 1999 · S/N 1054N44YYYankee LLC · Kasilof, AKBuilt 1979 · S/N 18-7909069N4500RWork Edward · Sneads Ferry, NCBuilt 1965 · S/N 28-21199N4500WMagalsky Jacob J · Wilsall, MTBuilt 1980 · S/N 18-8009019N4501EOptima Aviation LLC DBA · Lewisville, TXS/N 17271614N4501RNess James H · Phoenix, AZBuilt 1965 · S/N 28-21200N4503YSteppler Dean M · Culbertson, MTBuilt 1971 · S/N 18-8923N4504YCronin Monty A · Gettysburg, SDBuilt 1971 · S/N 18-8924N4505ASteadman Norman W · Arlington, TXBuilt 1956 · S/N 22-3810N4505RFayal Kenneth E Jr · Bend, ORS/N 28-21205N4506APennsylvania College Of Technology · Williamsport, PAS/N 22-3811N4506MBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-881N4506RCruz Roberto Jr · Douglasville, GABuilt 1965 · S/N 28-21206
Back to AD 79-10-03 R2