AD 2012-04-10

Registered aircraft · 175

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

N1164HHall Nathan M · Shepherd, MTBuilt 1948 · S/N 15AC-179N1170HBeckman Thomas J · Pocahontas, ARBuilt 1948 · S/N 15AC-183N1175HKrummrey Steven C · Munith, MIFirst renewal noticeBuilt 1948 · S/N 15AC-188N1178HLarter Edward A · Franklin, NHBuilt 1948 · S/N 15AC-199N1179HMann Thomas A · Ford, WABuilt 1948 · S/N 15AC-190N1182HWitherspoon Alexander · Sandy, ORBuilt 1948 · S/N 15AC-192N1183HMelby Justin D · Stoughton, WIBuilt 1948 · S/N 15AC-194N1186HLozier Jesse E · Coudersport, PABuilt 1948 · S/N 15AC-198N1188HWitteveen Mark J · Kodiak, AKS/N 15AC-47N1192HEberhardt William G · Orland, MEBuilt 1948 · S/N 15AC-204N1203HZimmer Dennis DBA · Pennock, MNS/N 15AC-215N1204HCompton Adam J · Wasilla, AKBuilt 1948 · S/N 15AC-216N1209HNelson Chester C · Little Falls, MNBuilt 1948 · S/N 15AC-221N1211HSchelde Jack D · Cook, MNBuilt 1948 · S/N 15AC223N1220HScroggs Jack F · Anchorage, AKBuilt 1948 · S/N 15AC-232N1224HCorcoran Timothy J · Aurora, ORFirst renewal noticeS/N 15AC-236N1226HThorvilson Samuel R · Palmer, AKBuilt 1948 · S/N 15AC-238N1227HSutton Aircraft Salvage LLC · Palmer, AKBuilt 1948 · S/N 15-AC239N1229HMattfield Weldon D · Bovey, MNFirst renewal noticeS/N 15AC-241N1233HRamberg Stephen Jon · Saint Louis Park, MNS/N 15AC-245N1234HSpear Tarik W · Fairbanks, AKBuilt 1948 · S/N 15AC246N1235HTravis Michael D · Anchorage, AKBuilt 1948 · S/N 15AC-247N1240HDestefano Patrick S · Bryan, TXS/N 15AC-252N1250HPhelps Lee D · Juneau, AKBuilt 1947 · S/N 15AC-262N1252HPallasch Cooper William · Denton, TXBuilt 1948 · S/N 15AC-264N1253HTschepen Leo R · Bisbee, NDBuilt 1948 · S/N 15AC-265N1259HSibley Dean R · Arcadia, CABuilt 1948 · S/N 15AC-271N1261HGregg Larry R · Pine City, MNBuilt 1948 · S/N 15AC-273N1264HSaladino Matthew G · Katy, TXBuilt 1948 · S/N 15AC-276N1266HStoker Paul M · Wasilla, AKBuilt 1949 · S/N 15AC279N1267HRetroair Restoration LLC · Big Lake, AKBuilt 1948 · S/N 15AC-278N1268HBbl LLC · Louisville, KYBuilt 1948 · S/N 15AC-282N1270HBuehlman Peter · Laveen, AZBuilt 1948 · S/N 15AC-281N1271HAmundson Kimber L · Eagle River, AKS/N 15AC-284N1277HRegistered aircraftBuilt 1948 · S/N 15AC293N1279HRichmond Brian G · Rhome, TXS/N 15AC-295N1283HMurphy George W · Willow, AKS/N 15AC-299N1285HWoodford John E · Madison, WIBuilt 1948 · S/N 15AC-301N1287HNelson Chester C · Little Falls, MNBuilt 1948 · S/N 15AC-303N1289HTranby Wayne A · Fargo, NDBuilt 1948 · S/N 15AC-306N1293HAyers Mark T · Whitney, TXS/N 15-AC-311N1294HWolbert Joseph P · Canton, GABuilt 1948 · S/N 15AC-318N1301HFair David E · Anchorage, AKFirst renewal noticeBuilt 1949 · S/N 15AC-325N1302HN1302h LLC · Levering, MIS/N 15AC-333N1304HShade Eric L · Dillingham, AKS/N 15AC-330N1308HDoose Paul · Wheeling, ILBuilt 1949 · S/N 15AC-338N1309HBrodie James W · Lind, WABuilt 1949 · S/N 15AC-340N1312HZadnikar Brian M · Eveleth, MNBuilt 1949 · S/N 15AC-342N1320HPoliti Terris P · Lake Placid, NYBuilt 1949 · S/N 15AC-354N1322HSynnes Greggory M · Killdeer, NDBuilt 1949 · S/N 15AC-356
Back to AD 2012-04-10