AD 72-01-07

Registered aircraft · 1,150

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

N120TMurphy Janet A · Stafford, KSBuilt 1952 · S/N 18-2234N1210ACaneen Jeremy M · Wasilla, AKBuilt 1951 · S/N 18-823N1214ARegistered aircraftBuilt 1951 · S/N 18-828N1219AFeltman Joshua C · Kenai, AKS/N 18-834N1221AGerbi Charles R Trustee · Auke Bay, AKBuilt 1951 · S/N 18-832N1222ADawley Creek Ranch Nv LLC · Ruby Valley, NVBuilt 1951 · S/N 18-837N1226AWalsh Brendan · Seattle, WAS/N 18-841N122BEBarton Preston S · San Antonio, TXS/N 182360N122TCarraher Timothy J · Spalding, NEBuilt 1952 · S/N 18-2236N1233ADecker Leon T · Hollister, CABuilt 1951 · S/N 18-848N1238AArnold Joe R · Burns, ORBuilt 1951 · S/N 18-1031N1244APickard Martha Anne Gabriel · Hudson, OHBuilt 1957 · S/N 18-1037N1246Lablanc Michael T · Intl Falls, MNBuilt 1954 · S/N 18-3347N1246AGay Ranch Inc · Broadus, MTBuilt 1951 · S/N 18-1039N1248ABaugh Andrew Lawrence · Anchorage, AKBuilt 1951 · S/N 18-1041N1249AAirmotive Service LLC · Brigham City, UTBuilt 1951 · S/N 18-1042N124GSDetommaso James F · North Pole, AKBuilt 1956 · S/N 5287N124TTappan East LLC · New Philadelphia, OHBuilt 1952 · S/N 18-2238N1251APappas Timothy G · Big Lake, AKS/N 18-1047N1252CDavis Doyle M · Clancy, MTBuilt 1953 · S/N 18-2491N1253ALange Keith J · Wasilla, AKBuilt 1951 · S/N 18-1049N1258ALake Country Lodge Inc · Port Alsworth, AKS/N 18-1053N1258CSmith Samuel Richard · Seward, AKBuilt 1953 · S/N 18-2497N1259AHigh Exposure Inc · Wilmington, DEBuilt 1951 · S/N 18-1054N1259CBowers Michael · Chugiak, AKBuilt 1953 · S/N 18-2500N125FGState Of Alaska · Kodiak, AKBuilt 1951 · S/N 18-1046N1263AMurphy Janet A · Stafford, KSBuilt 1951 · S/N 18-1059N1264APierskalla Nicolas B · Wasilla, AKBuilt 1951 · S/N 18-1060N1265AWalker Matthew J Trustee · Delta Junction, AKS/N 18-1061N1268ATegerdine Charley D · Sterling, AKBuilt 1951 · S/N 18-1063N126THentges Kelley R · Frazer, MTS/N 18-2240N1270ASnow Richard C · Wasilla, AKBuilt 1951 · S/N 18-1065N1272AJacoby Peter A · Tucson, AZBuilt 1951 · S/N 18-1068N1277AWagner Tyler M · Sitka, AKBuilt 1951 · S/N 18-1072N1278ARegistration Pending · Palmer, AKRegistration pendingBuilt 1951 · S/N 18-1074N127TBenham Charles · Lorena, TXBuilt 1952 · S/N 18-2241N1283AFritz David A · Wasilla, AKBuilt 1951 · S/N 18-1087N1291ASeale Sidney Joseph · Condon, ORBuilt 1951 · S/N 18-1094N1291CVand Flyve Klub · Newfolden, MNS/N 18-2502N1294AHubbard John H · Riverside, WAS/N 18-1097N1295AJenski Kobie · Sutton, AKBuilt 1951 · S/N 18-1098N1297AOrwick Robert J · Newell, SDS/N 18-1101N1304ABilben Steve W · Kasilof, AKBuilt 1951 · S/N 18-1108N1305AAir Dakota Flite Inc · Hettinger, NDBuilt 1951 · S/N 18-1109N1312ABowen Haldor S · Sandpoint, IDBuilt 1951 · S/N 18-1114N1314AK & D Livestock Inc · Volborg, MTBuilt 1951 · S/N 18-1120N1317ADixon Douglas C · Anchorage, AKBuilt 1951 · S/N 18-1124N1320ATerra Firma Aviation LLC · Bowman, CABuilt 1951 · S/N 18-1126N1322AWrobel Sean M · Weatherford, TXBuilt 1951 · S/N 18-1128N1324AJagow Charles P · Fairbanks, AKBuilt 1951 · S/N 18-1134
Back to AD 72-01-07