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.

N1112ABallek Jeffery A · North Pole, AKBuilt 1951 · S/N 18-704N1113CBrown Daniel A · Gettysburg, PABuilt 1953 · S/N 18-2199N1117CWommack Leland E · Lone Star, TXBuilt 1953 · S/N 18-2204N111DBRaven Aviation LLC · Lewistown, MTBuilt 1953 · S/N 18-3682N1124Bollinger Karen S · Fairbanks, AKBuilt 1955 · S/N 18-3985N1127ASerie Dennis P · Chugiak, AKBuilt 1950 · S/N 18-720N11284Horton Rick S · Plains, MTBuilt 1956 · S/N 18-4737N1128ACarson Dean B · Anchorage, AKBuilt 1951 · S/N 18-721N1129Houghton John D · Palmer, AKBuilt 1954 · S/N 18-4022N1129ABredin William B · Anchorage, AKBuilt 1951 · S/N 18-722N1130Kennedy William · Sheffield, TXBuilt 1954 · S/N 18-3510N1130ACoxon William O IV · Church Hill, MDBuilt 1951 · S/N 18-723N1131ARizzo Christian · Clover, SCBuilt 1951 · S/N 18-725N1133Cub N1133 LLC · Logan, UTBuilt 1954 · S/N 18-3558N1136Ekstrom Eric S · Eagle River, AKS/N 18-4041N1144AKramer John Edward · Conroe, TXBuilt 1951 · S/N 18-737N1148ATyrrell Luke L · Fairbanks, AKBuilt 1951 · S/N 18-742N1149AFodor Scott M · Barryton, MIBuilt 1951 · S/N 18-743N114TAviation Training Solutions LLC · Hilo, HIBuilt 1952 · S/N 18-2228N1150AMountain Air Spray Company · Craig, COBuilt 1951 · S/N 18-744N1151ALangdon William W · Lebanon, ORBuilt 1951 · S/N 18-745N1152CTaylor Jimmie D · Hedley, TXBuilt 1953 · S/N 18-2210N1153AHolder Robert W · Pittsfield, PABuilt 1968 · S/N 18-747N1154CStewart Daniel C III · Chugiak, AKBuilt 1953 · S/N 18-2212N1157CCavill Wayne E · Ryegate, MTBuilt 1953 · S/N 18-2458N1160AAday Bennie J · Las Cruces, NMS/N 18-757N1161ALindemann Robin · Anchorage, AKS/N 18-2691N1169AK-Air Service LLC · Gakona, AKBuilt 1951 · S/N 18-767N116TRobinett Barton L · Frankston, TXBuilt 1952 · S/N 18-2230N1170AAbbott Barry R · Sterling, AKBuilt 1951 · S/N 18-768N1175ABurmeister Aaron R · Nenana, AKBuilt 1951 · S/N 18-777N117TLOver-Head Productions Inc · Wilmington, DES/N 18-2231N1181YMeehleis Mark G · Anchorage, AKBuilt 1952 · S/N 18-2144N1184CGanim Rose · Haydenville, MABuilt 1953 · S/N 18-2467N1185ALovgren Dean · Morrowville, KSBuilt 1951 · S/N 18-792N1189CHorton Harold E · Jber, AKS/N 18-2470N118DKReynolds Thomas J · Dillon, MTS/N 18-7540N118EMSharp Robert M Trustee · Jenks, OKS/N 18-1853N118SMMars Samuel C · Madison, MSS/N 18-2175N1190CStein Adam Kent · Joseph, ORBuilt 1954 · S/N 18-2473N1192AMyers Dale C · King Salmon, AKBuilt 1951 · S/N 18-802N1192CBrewer Donald S · Paragould, ARBuilt 1953 · S/N 18-2476N1195AParker Stephen H · Montgomery, TXBuilt 1951 · S/N 18-803N1197ABouchard Ron · Lambert, MTBuilt 1951 · S/N 18-804N1197CHitch Dixon S · Malta, MTBuilt 1953 · S/N 18-2480N1198Davis Barry E · Carrollton, GABuilt 1953 · S/N 18-3334N1200ABay Kelly M Trustee · Glennallen, AKBuilt 1951 · S/N 18-1200N1202AEldringhoff Jim · Wecota, SDBuilt 1951 · S/N 18-810N1209ACorbin Richard · Waterville, NYBuilt 1951 · S/N 18-820N120KHPackard Randall C · Anchorage, AKS/N 18-3511
Back to AD 72-01-07