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.

N1323HMcginnis John W · Strawberry Plains, TNBuilt 1948 · S/N 15AC-357N1324HHudson Aircraft Service · Tallahassee, FLBuilt 1949 · S/N 15AC-359N1329HDetwiler Chad R · Urbana, OHBuilt 1949 · S/N 15AC366N1330HNelson Chester C · Little Falls, MNS/N 15AC-367N1331HQualitair LLC · MichelstadtBuilt 1949 · S/N 15AC371N1332HDrake Tyler M · Fairbanks, AKS/N 15AC-372N1340HJacobs Robert C · Eureka, MTBuilt 1949 · S/N 15AC-380N1345HNelson Chester C · Little Falls, MNBuilt 1949 · S/N 15AC-388N1346HSchwing Emily E · Girdwood, AKS/N 15AC-389N1348HKoepplinger Dawn M · Chesaning, MIBuilt 1949 · S/N 15AC-391N1349HRose Randy James · Egg Harbor, WIBuilt 1949 · S/N 15AC-392N1352HMorris Dennie R · North Fort Myers, FLBuilt 1949 · S/N 15AC-396N1353HHeredia Richard A · Gilroy, CABuilt 1949 · S/N 15AC397N1354HOwen Toy C · Anchorage, AKBuilt 1949 · S/N 15AC-398N1356HHatley Byron J · Sparks, NVBuilt 1949 · S/N 15AC-403N1357HPolhemus John W Jr · Bowie, TXS/N 15AC-404N1361HWebb Randol B Jr · Sherman, CTBuilt 1949 · S/N 15AC-408N1363HAsay Philip W · Anchorage, AKBuilt 1949 · S/N 15AC-410N1365HConger Gary L · Oneida, WIBuilt 1949 · S/N 15AC-413N1368HWestlake Aviation LLC · Seattle, WABuilt 1949 · S/N 15AC-417N1372HNelson Chester C · Little Falls, MNBuilt 1949 · S/N 15AC-421N1376HMikos Nicholas J · Anchorage, AKS/N 15AC-425N1378HPinsky Harold M · Ann Arbor, MIBuilt 1949 · S/N 15AC-427N1381HSolek Kyle M · Copper Center, AKS/N 15AC430N1384HGoodhue David H · Vancouver, WABuilt 1949 · S/N 15AC-434N1387HAbrahamson Joe Trustee · Phoenix, AZFirst renewal noticeBuilt 1949 · S/N 15AC-438N1391HFronhofer Mark · Franklin, VTBuilt 1949 · S/N 15AC-442N1396HRiggin Flight Service Inc · Madison, SDS/N 15AC-447N1398HMiller Debra L · Anchorage, AKS/N 15AC-449N1403HSutter Richard J · Kooskia, IDBuilt 1950 · S/N 15AC-454N1409HLissow William M · New Port Richey, FLS/N 15AC-461N1410HCramer Justin R · Eagle River, AKBuilt 1949 · S/N 15AC-462N1413HBloomfield Management Inc · Dodgeville, WIBuilt 1949 · S/N 15AC-433N1414HSardella Jeff · Knoxville, TNS/N 15AC470N1415HGullickson Gregory D · Anchorage, AKBuilt 1949 · S/N 15AC-471N1417HHoag Michael R · Three Rivers, MIBuilt 1949 · S/N 15AC-475N1418HErickson Richard F · Wasilla, AKS/N 15AC-478N1420HWagner James M Trustee · Reno, NVS/N 15AC-477N1421HNelson Chester C · Little Falls, MNBuilt 1950 · S/N 15AC-482N1422HNedley A Lloyd · Birmingham, MIRegistration revokedBuilt 1950 · S/N 15AC484N1423HSchneider Paul · Silverdale, WABuilt 1950 · S/N 15AC-485N1427HMolt Keaton V · Burns, ORBuilt 1950 · S/N 15AC-491N1428HParrish Sidney J · Manley Hot Springs, AKBuilt 1950 · S/N 15AC-489N1430HHardy John R · Wasilla, AKBuilt 1949 · S/N 15AC-493N1433HCowley Curt J · Independence, ORBuilt 1950 · S/N 15AC-496N1441HHolder Jimmy R · North Pole, AKS/N 15AC-506N1444HHaugan James A · Two Harbors, MNS/N 15AC-511N1448HWilder Jon R Jr · Glenfield, NYBuilt 1950 · S/N 15AC-517N1450HSoltis Francis J · Chugiak, AKBuilt 1950 · S/N 15AC-519N1451HCavanaugh Darrel N · Wasilla, AKFirst renewal noticeBuilt 1950 · S/N 15AC-520
Back to AD 2012-04-10