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.

N525CSPrivitt Bret J · Forest Hill, TXBuilt 1973 · S/N 270-73N525FLSiebert Derrick R · Wausau, WIBuilt 1971 · S/N 28-7125357N525PULindsay Aviation Inc · West Seneca, NYS/N 28-8316102N525SAbles Kenneth M · Taylor, AZBuilt 1989 · S/N 369N52602Hutch Aviation Inc · Zavalla, TXBuilt 1980 · S/N 17274562N5260DMeyer Kevin · Hooper, NEBuilt 1979 · S/N 17272478N5260KPacific Fleet Aviation LLC · Rochester, NYBuilt 1980 · S/N 17274035N5260RSouthern Aero LLC · Homestead, FLBuilt 1974 · S/N 17263474N5260WNance James B · Terrell, TXBuilt 1962 · S/N 28-305N5261UBackus Gary Carl · Chesapeake, VABuilt 1980 · S/N 172RG0308N5262HBun Air Corp · Bedford, PABuilt 1975 · S/N 17265388N5262LWilliams Gregory L · Tehachapi, CABuilt 1967 · S/N 28-4560N52635Allard Michael · Penrose, COS/N 17274573N5263BFerland Erik · Everett, MABuilt 1957 · S/N 1126N5263LRjl Aero Inc · Valparaiso, INBuilt 1967 · S/N 28-4561N5263WCjco Holdings LLC · Venus, TXBuilt 1962 · S/N 28-309N5264DPironti Bennett D · Long Valley, NJS/N 17272481N5264KRmg Aviation LLC · Newark, DEBuilt 1980 · S/N 17274036N5264WGray Donald B Trustee · Houston, TXBuilt 1961 · S/N 28-310N5264XTank David M · Cambridge, OHBuilt 1969 · S/N 170N52654Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274576N5265DFly 172rg LLC · Peoria, AZBuilt 1979 · S/N 17272482N5265ETree Top Flying Service Inc · Clarksville, TNBuilt 1978 · S/N 17271804N5265RMoss Hill Airport Inc · Kinston, NCBuilt 1974 · S/N 17263479N5265WDwight Marketing Corporation · Caldwell, KSBuilt 1962 · S/N 28-311N5265XSwanton Peter K · Willits, CABuilt 1969 · S/N 124N5266DColemanation Investments LLC · Naperville, ILBuilt 1979 · S/N 17272483N5266ENatchez Flight Training LLC · Natchez, MSBuilt 1978 · S/N 17271805N5266KCorsicana Aviation Training Services LLC · Corsicana, TXBuilt 1980 · S/N 17274037N5266UN5266u LLC · Brookfield, ILBuilt 1980 · S/N 172RG0312N5266WMichigan Sport Aviators Inc · Midland, MIBuilt 1962 · S/N 28-312N5266XKrabbenhoft J F · Amenia, NDBuilt 1969 · S/N 191N52671Carver Aero LLC · Muscatine, IABuilt 1981 · S/N 17274577N5267EBrudelie Alan C · Lewisville, MNBuilt 1978 · S/N 17271806N5267LBlasi Aviation LLC · Valley Center, KSBuilt 1967 · S/N 28-4565N5267PCarter Jeffrey Lee · Cameron Park, CABuilt 1958 · S/N 24-303N52683Cobb John Mark · Fayetteville, TNBuilt 1981 · S/N 17274579N52685Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17274580N5268BCabbage David A · Colville, WABuilt 1957 · S/N 1131N5268HGrander Aviation LLC · Panama City Beach, FLBuilt 1975 · S/N 17265389N5268JReach For Skies LLC · San Antonio, TXBuilt 1980 · S/N 17273751N5268KSorbi Aviation Inc · El Cajon, CABuilt 1980 · S/N 17274038N5268RJohnson Steven D · Oklahoma City, OKS/N 17263482N5268TDykes Don A · Houston, TXBuilt 1972 · S/N 28-7205252N5269LKarel John · Stillwater, MNBuilt 1967 · S/N 28-4567N5269TKailua Aviation LLC · Moorestown, NJBuilt 1972 · S/N 28-7205253N5269WGoetz David B · Gleason, WIS/N 28-315N526ECChapman Daniel W · Soldotna, AKBuilt 1986 · S/N 1689N526FRoush Heith · Cabot, ARS/N 17700932N526KGWalters David M · Wasilla, AKS/N 18-4294
Back to AD 79-10-03 R2