AD 94-05-05 R1

Registered aircraft · 26,230

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.

N94172Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1946 · S/N 1495N94174Stork Matthew J · Mulberry, FLBuilt 1946 · S/N 1497N94175Preslicka Eric · York, NEBuilt 1946 · S/N 1498N94176Wood Michael E · Whitesburg, TNS/N 1499N94184Zheng Kevin · S San Fran, CABuilt 1946 · S/N 1507N94189Champion James D · Urbandale, IABuilt 1946 · S/N 1512N9418ARamsey Matthew A · Hermosa, SDBuilt 1949 · S/N 15239N9418UAftcloud Inc · Ontario, CABuilt 1976 · S/N 15078366N94196Cohen Sydney B · Wausau, WIBuilt 1946 · S/N 1519N941LCMartin Robert L III · Stuarts Draft, VAS/N 1941N9420BJones Jeremy R · Lampasas, TXS/N 55220N9420USouthquarter Aviation LLC · Youngstown, OHBuilt 1976 · S/N 15078368N9421AWillie Brett A · Decorah, IABuilt 1949 · S/N 15242N9422BFallbrook Air Service · Fallbrook, CAS/N 55222N9422UHortman Ryan Davis · Summerville, SCBuilt 1976 · S/N 15078370N9423ADyer Shane E · White Hills, AZBuilt 1949 · S/N 15244N9423ESchunk Stephan W · Caledonia, NYBuilt 1946 · S/N 11AC-1060N9424HMcclung Richard C · Rockford, ILBuilt 1962 · S/N 86N9425AZimmerman Scott Andrew · Palmdale, CABuilt 1949 · S/N 15246N9425BGloeckler Alex · Pearl City, ILBuilt 1958 · S/N 55225N94287Callahan Thomas D · Shaker Heights, OHS/N TC-1N9428AHoyt Richard A · Webster Groves, MOBuilt 1949 · S/N 15249N9429ARegistration Pending · Chicago, ILRegistration pendingBuilt 1950 · S/N 15461N9429UTangleport LLC · Amarillo, TXBuilt 1976 · S/N 15078377N942XAClymer Jordan · Cape Canaveral, FLS/N 15070510N94307Bellings Eric E · Neshkoro, WIBuilt 1946 · S/N 1530N9430AWalker Neiman J · Denton, TXBuilt 1949 · S/N 15251N9430BFuture Flyers Of Connecticut LLC · Simsbury, CTBuilt 1958 · S/N 55230N9430MKruschwitz David A · Anchorage, AKBuilt 1974 · S/N 15075669N94310Rioux Roger · Corpus Christi, TXBuilt 1946 · S/N 1533N94311Broadwell Eric · Woodstock, GAS/N 1534N94315Whitmire Joseph A · Soddy Daisy, TNBuilt 1946 · S/N 1538N94316Nowicki John W · West Chicago, ILBuilt 1946 · S/N 1539N9431ADelta Ridge Farms LLC · Oak Grove, LABuilt 1949 · S/N 15252N94320Gap Aircrafts LLC · Dover, DEBuilt 1946 · S/N 1543N9433ABohl Howard M · Temecula, CABuilt 1949 · S/N 15254N94348Devlin Robert E · Hillsborough, NJBuilt 1946 · S/N 1571N9434BNamtvedt Erik · Wasilla, AKS/N 55234N94357Ratzlaff James P · Newton, KSBuilt 1946 · S/N 1580N9435ARoberts Ralph Russell · Seaman, OHBuilt 1949 · S/N 15256N94367Flying L Aircraft Inc · Fort Denaud, FLBuilt 1946 · S/N 1590N9436APyeatt David W · Palm Beach Gardens, FLBuilt 1950 · S/N 15462N9436BWhitsell Jesse T · Sterling, CTBuilt 1958 · S/N 55236N94378Kittner Robert T · Ellenville, NYBuilt 1946 · S/N 1601N9437UAom Aircraft LLC · Wilmington, DES/N 15078385N9438ACorder Charles W · Fairfield, OHBuilt 1949 · S/N 15259N9439AFullerton Paul S · Saint Ignace, MIBuilt 1949 · S/N 15260N9439URautiola Patricia H · Rosemount, MNS/N 15078387N94403Mcgee Danny P · S Prince Geo, VABuilt 1949 · S/N 5035N94407Swan John E Jr · Jefferson City, MOS/N 5039
Back to AD 94-05-05 R1