OpenAirDocs.org
AD 47-47-01

Registered aircraft · 1,242

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

N101KRVlach Ronald G · Fremont, NEBuilt 1946 · S/N 12-53N101ZYBartel Gordon L · Willow, AKS/N 12 1935N103BSFixed Gear LLC · Sherwood, ARBuilt 1947 · S/N 123988N105JHBaxter Brandon C · Wasilla, AKBuilt 1947 · S/N 12-3240N1121WDeleon Joseph M · Saint Petersburg, FLBuilt 1947 · S/N 12-2429N112PATaylor Jay S · Anchorage, AKBuilt 1947 · S/N 12-2158N12464Bell Todd J · Joliet, MTBuilt 1947 · S/N 12464N126GSSanoski Gregory G · Talkeetna, AKS/N 12-1270N127GSSanoski Gregory G · Talkeetna, AKS/N 12-273N12MZRatfield Dwaine C · Onamia, MNS/N 12-2930N13DBBauer Dereck R · Springfield, ORS/N 12-2919N13YFTemple Peter L · Harrisville, NHS/N 12-848N143JJKinery Clifford J · Kewadin, MIBuilt 1947 · S/N 12-1705N146MRiddles Michael P · Poulsbo, WABuilt 1946 · S/N 12-703N149AKSmith Megan · Palmer, AKS/N 121338N14HRRegistered aircraftBuilt 1947 · S/N 12-2853N1553MRubbert Jan D · Upham, NDBuilt 1947 · S/N 12-3125N157PJCarnighan Kelly · New Albany, INBuilt 1946 · S/N 12-1152N15JKCaskey Martin K · Paso Robles, CABuilt 1946 · S/N 12-265N160HLProbasco Mitchell L · Floydada, TXBuilt 1946 · S/N 12-1636N1706BWagstrom Wayne A · Aurora, UTS/N 12-1562N170WTBarber Shane C · Willow, AKS/N 12-753N17NVLeseberg Mark E · Boulder City, NVBuilt 1946 · S/N 12-863N1947YBitterroot Ventures LLC · Show Low, AZBuilt 1947 · S/N 12-3253N19MYCamino Thomas J · Buffalo, WYBuilt 1946 · S/N 12-2274N1SETin Cup Aviation LLC · Lakeland, FLBuilt 1947 · S/N 12-2036N2087CLarkin Marion J · Salome, AZS/N 12-3497N208CKKarel Craig F · Filer, IDBuilt 1946 · S/N 12-569N222MJHonore Breen Aviation LLC · Allegan, MIS/N 12-1905N223CGBeckett Jesse · Lakeway, TXBuilt 1947 · S/N 12-2480N2308MStrate Joel R · Roberts, WIBuilt 1946 · S/N 12-1475N2309MCranford Billy J · Wasilla, AKBuilt 1946 · S/N 12-1476N2314MMullins Esten R · El Paso, TXBuilt 1946 · S/N 12-1478N2315MBalfany Michael D · Kingston, NVBuilt 1946 · S/N 12-1479N2316MRed Tail Aviation LLC · Pueblo, COBuilt 1946 · S/N 12-1480N2318MRentz Travis Kyle · Palmer, AKBuilt 1946 · S/N 12-1385N2322MJohnson Walter H · White Stone, VABuilt 1946 · S/N 12-1482N2324MLeonard Stephen P · Anchorage, AKBuilt 1946 · S/N 12-1488N2325MSharp Frank J DBA · Windermere, FLBuilt 1946 · S/N 12-1491N2326MNapoleon Christopher D · Allegany, NYBuilt 1946 · S/N 12-1490N2327MPence Dale E · Richmond, MOBuilt 1946 · S/N 12-1390N2328MDraveliing Larry J · Wasilla, AKBuilt 1946 · S/N 12-1483N2329MWard Doran L · Glennallen, AKBuilt 1946 · S/N 12-1391N232WWells Garry L · Scotia, NEBuilt 1946 · S/N 12-701N2330MSquiers Jeffrey S · Independence, MNS/N 12-1393N2341MMarcum Raymond A · Anchorage, AKS/N 12-1604N2342MSteens Mountain Packers · Frenchglen, ORBuilt 1946 · S/N 12-1605N2344MHershey Eric F · Wasilla, AKBuilt 1946 · S/N 12-1485N2346MHendrickson Gary A DBA · Gold Beach, ORS/N 12-1609N2348MSurgent Richard L · Wall Township, NJBuilt 1947 · S/N 12-1607
Back to AD 47-47-01