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.

N2138AKingdom Air Corp · Sutton, AKBuilt 1952 · S/N 18-1859N2139AAero Seat Inc · Sterling, COBuilt 1952 · S/N 18-1861N213TFlemmer Richard W · Park City, MTBuilt 1953 · S/N 18-2327N2150AAerial Sign North · Lakewood, NJBuilt 1956 · S/N 18-1862N2151AMichaud Shawn R · Glenburn, MES/N 18-1863N2154ANoska Frank S IV · Wasilla, AKBuilt 1952 · S/N 18-1864N2156AIberlin Ranch · Gillette, WYBuilt 1952 · S/N 18-1870N2158AHowlett Corey W · Wasilla, AKBuilt 1953 · S/N 18-1873N218TSullivan Ross A · Saint Helena, CABuilt 1953 · S/N 18-2332N219PSClark Gloria L Trustee · Gillette, WYBuilt 1954 · S/N 18-4037N21NTreichler Peter C · East Aurora, NYBuilt 1953 · S/N 18-2865N2205ARiggin Flight Service Inc · Madison, SDBuilt 1952 · S/N 18-1881N2207ASmith David C · Brewster, WABuilt 1951 · S/N 18-1882N221BCChristman Eric R · Wasilla, AKS/N 18-5570N221TMee Dennis M · Portsmouth, NHBuilt 1953 · S/N 18-2335N2227CCain Jeffrey B · Godley, TXBuilt 1954 · S/N 18-4011N2230YRickman Wanda M · Absarokee, MTS/N 18-2310N223TFalconeri Michael A · Ketchikan, AKS/N 18-2337N224TVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1953 · S/N 18-2338N2261AFlying Start LLC · Wilmington, DEBuilt 1952 · S/N 18-1887N2265AAsher Kevin C · Wasilla, AKBuilt 1952 · S/N 18-1888N226TMcallister Hunter · Medford, ORBuilt 1953 · S/N 18-2340N2272ZMohar Fred B Jr · Turner, MTBuilt 1954 · S/N 18-3549N227TYoung Donald O · Easley, SCBuilt 1953 · S/N 18-2341N2287YJetran LLC · Horseshoe Bay, TXS/N 18-2434N228TWb Aviation LLC · Saint Jo, TXBuilt 1953 · S/N 18-2342N229TGagnon Matthew I · Fairbanks, AKS/N 18-2343N22KYGamma Holdings LLC · Denver, COS/N 18-3588N2302VBeacon West LLC · Hayden Lake, IDS/N 18-4308N2304YHrutkay Charles S · Scenery Hill, PABuilt 1952 · S/N 18-2215N230THague Creek Aviation LLC · Phoenix, AZS/N 18-2344N231TBates Dallas W · Slana, AKBuilt 1953 · S/N 18-2345N2322AMertens Darrel W · Sterling, COBuilt 1952 · S/N 18-1898N2325AReece Andy · Marysville, WAS/N 18-1901N234TDelia Patrick S · Palmer, AKBuilt 1953 · S/N 18-2348N2353XB R Trucking LLC · Cut Bank, MTBuilt 1956 · S/N 18-4239N2359PRyan Good Aviation LLC · Sioux Falls, SDBuilt 1955 · S/N 18-4245N235TBossert Brett · Tucson, AZBuilt 1953 · S/N 18-2349N2361AGeorge Raymond C · Wasilla, AKS/N 18-1906N2366AShort Ann C · Neillsville, WIBuilt 1952 · S/N 18-1914N2367ADanreuther Keith E · Loma, MTS/N 18-1916N2368AMondt Erik C · Waterloo, IABuilt 1952 · S/N 18-1921N236TStickley John E · Lothian, MDBuilt 1953 · S/N 18-2350N237WTGage Scott M · Anchorage, AKS/N 18 237N238THoffer William T · Orr, MNBuilt 1953 · S/N 18-2352N23TTEsp Ranch · Hardin, MTS/N 18-6684N241TJenison Lawrence E · Chelsea, MIBuilt 1953 · S/N 18-2355N2428DLee Brenda T · Boonville, NYS/N 18-1934N243THillestad Darrell · Aberdeen, SDBuilt 1953 · S/N 18-2357N2444AHoward Nathan L · Fairbanks, AKBuilt 1952 · S/N 18-1939
Back to AD 72-01-07