AD 94-05-05 R1

Registered aircraft · 26,232

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:94-05-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
  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.

N77447Kuharske Jeffrey H · Groveland, FLBuilt 1946 · S/N 11890N7744FThoren Patrick · Tenino, WABuilt 1966 · S/N 15063844N7744GMoore Jeffrey D · Cleveland, NYBuilt 1967 · S/N 138N7744UArnold David L · Portland, ORBuilt 1964 · S/N 17251744N77452Inderbitzin Mark Richard · Tacoma, WABuilt 1947 · S/N 11896N77453Mabry Dale C · San Antonio, TXBuilt 1946 · S/N 11897N77454Granger William B · Lake City, MIBuilt 1946 · S/N 11898N77457Sprandel Paul A · Kendallville, INBuilt 1946 · S/N 11901N7745UHodges Charles E · Grain Valley, MOBuilt 1964 · S/N 17251745N77463Lohmeyer Wayne D · Katy, TXBuilt 1946 · S/N 11907N77464Gustafson Bruce L · Eugene, ORBuilt 1946 · S/N 11908N77466Quatro Queso Dos Fritos LLC · Buena Park, CABuilt 1946 · S/N 11910N77468Nulsen Gillian E · Greenbrier, ARBuilt 1946 · S/N 11912N7746TWilson Steven C · Raleigh, NCBuilt 1960 · S/N 47346N7746XHennings Noran E · Des Moines, WABuilt 1961 · S/N 17248246N77473Johnson James R · Etna, CABuilt 1946 · S/N 11917N77474Bolin Michael A · Spokane, WABuilt 1946 · S/N 11918N77475Freeland David D · Leawood, KSBuilt 1946 · S/N 11919N7747UCoastal Zoom LLC · Davenport, FLBuilt 1964 · S/N 17251747N77480White John D · Eagle River, AKBuilt 1946 · S/N 11924N77486Rankin Paul D · Hudson, WIBuilt 1946 · S/N 11930N77488Thomas Michael R · Marshall, MOFirst renewal noticeBuilt 1946 · S/N 11932N7748EKuntz William · Wilmington, NCS/N 17548N7748GSchilling Erik D · Cumming, GABuilt 1973 · S/N 15074724N77493Weeks James E · Georgetown, TXBuilt 1946 · S/N 11937N77494Brisi Co · Wilmington, DEBuilt 1946 · S/N 11938N7749EGrant Matthew D · Alvord, TXBuilt 1959 · S/N 17549N7749LDouble Bridges Aviation LLC · Enterprise, ALBuilt 1970 · S/N 17259015N7749UN833tx LLC · Little Rock, ARBuilt 1964 · S/N 17251749N774MDecker Royce B · Deridder, LABuilt 1977 · S/N 15079345N77508Bma Group LLC · Carl Junction, MOBuilt 1946 · S/N 21999N7750UCoke Hartwell F · Quinton, VABuilt 1964 · S/N 17251750N7750XBurklund Joel H · Minneapolis, MNS/N 17248250N7750ZFisher William R · Jackson, TNBuilt 2018 · S/N 75-10763N7751TBehl Nathan S · Lewistown, MTBuilt 1960 · S/N 47351N77521Mile High Cub LLC · Erie, COBuilt 1946 · S/N 22012N77522Registered aircraftBuilt 1946 · S/N 22014N77524Aerospace Projects Support LLC · Mesa, AZBuilt 1946 · S/N 22015N7752EKountz Harvey J · Brockway, MTBuilt 1959 · S/N 17552N7752FBoulware James Curtis · New Smyrna Beach, FLBuilt 1966 · S/N 15063852N7752XCassell Peter B Jr · Stonewall, LABuilt 1961 · S/N 17248252N7752ZHarris Thaddeon A · Northfield, MNBuilt 1959 · S/N 18-7134N7753THollis Scott C · Sumpter, ORBuilt 1960 · S/N 47353N7753UAmyx Hiram R · Liberty, TXBuilt 1964 · S/N 17251753N77541Laczko Shelby E · Raleigh, NCFirst renewal noticeBuilt 1946 · S/N 22031N77549Pineland Holdings LLC · Gibsland, LABuilt 1946 · S/N 22040N7754EBurns Robert M III · Columbia, SCS/N 17554N7754XKendall David · Ferndale, CABuilt 1960 · S/N 17248254N77557Smith Aviation LLC · Springer, OKBuilt 1946 · S/N 22049N7755FHayhurst Shane R · Winfield, PAFirst renewal noticeBuilt 1966 · S/N 15063855
Back to AD 94-05-05 R1