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.

N2445AMcmillian Dean R · Wasilla, AKBuilt 1952 · S/N 18-1940N245KWCarson Cubs LLC · Yelm, WAS/N 18-2495N2461AGaller Mary D Trustee · Elysian, MNBuilt 1952 · S/N 18-1947N246LDHoppe Nicholas J · Big Lake, AKBuilt 1952 · S/N 18-1945N2474ZTeufel Jeffrey · North Pole, AKBuilt 1954 · S/N 18-3592N247TGriffin Kenneth D · Anchorage, AKS/N 18-2361N2487AHoffman Gary D · Spencer, NEBuilt 1952 · S/N 18-1956N2488APetrik Kale O · Sidney, MTBuilt 1952 · S/N 18-1969N2489ALong Patrick B · Buffalo, WYS/N 18-1957N248TGiannonatti Lance A · Ludlow, SDBuilt 1953 · S/N 18-2362N2491ACampbell Aviation Inc · Dutton, MTBuilt 1952 · S/N 18-1962N2494AOtto Justin · Lakeland, TNBuilt 1952 · S/N 18-1961N2496ASibille Keith C · Griffin, GABuilt 1952 · S/N 18-1963N2496PTri M LLC · Nikiski, AKS/N 18-4305N249TBigger Tires More Fun LLC · Anchorage, AKBuilt 1953 · S/N 18-2363N24QBFedorko Daniel J · Saylorsburg, PABuilt 1957 · S/N 18-5732N250TWhite William Brian · Apex, NCBuilt 1953 · S/N 18-2364N2510AIlgenfritz Don C Jr · Fairbanks, AKBuilt 1952 · S/N 18-1974N2511ABrierley Michael G Trustee · Sparks, NVBuilt 1952 · S/N 18-1971N2512AFell William P · Anchorage, AKS/N 18-1970N2514ABeard Michael Wayne · Eveleth, MNBuilt 1953 · S/N 18-2140N2515AClaus Jay G · Palmer, AKBuilt 1952 · S/N 18-1972N2516AAscension Aviation LLC · Gaylord, MIBuilt 1953 · S/N 18-2141N2518ARegistration Pending · Wasilla, AKRegistration pendingBuilt 1953 · S/N 18-2148N252TJanssen Jerry D · Barnesville, MNBuilt 1953 · S/N 18-2366N2534AWilcoxon James · Scobey, MTBuilt 1952 · S/N 18-2152N254TFindlay Harald · Charlotte, VTBuilt 1953 · S/N 18-2368N256TPulkrabek David P · Hutchinson, MNBuilt 1953 · S/N 18-2370N2576PWiltz Brothers Inc · Krotz Springs, LAFirst renewal noticeBuilt 1955 · S/N 18-4316N257TRegistration Pending · Pittsfield, MERegistration pendingBuilt 1953 · S/N 18-2371N2581ASattler Philip J · River Falls, WIBuilt 1952 · S/N 18-2157N2585ARipplinger Stephen M · Enderlin, NDS/N 18-2161N258TDiamond X LLC · Elko, NVBuilt 1953 · S/N 18-2372N2621AFox Jeff R · Soldotna, AKBuilt 1952 · S/N 18-2168N2625AGundersen James I · Townsend, MTBuilt 1952 · S/N 18-2170N262TBarnstormers Aerial Advertising LLC · North Myrtle Beach, SCBuilt 1953 · S/N 18-2376N264TPm Aviation LLC · Missoula, MTBuilt 1953 · S/N 18-2378N2660AN62689 Inc · Texarkana, TXBuilt 1952 · S/N 18-2184N2666PBerentson Bradley J · Westhope, NDBuilt 1955 · S/N 18-4390N267CMRegistered aircraftBuilt 1954 · S/N 18-3532N2681AKatzmarek Clay M · Wasilla, AKS/N 18-2186N2683ALovett Andre D · Anchorage, AKBuilt 1953 · S/N 18-2189N2684AMckinley I Blake Jr · Spokane Valley, WABuilt 1952 · S/N 18-2190N2688ALanham Rex E · Boise, IDBuilt 1953 · S/N 18-2194N2689AWomack W A · Jackson, LABuilt 1953 · S/N 18-2195N268TCline David R · Maryville, TNBuilt 1953 · S/N 18-2382N2695PDodge Alan J · Miles City, MTBuilt 1955 · S/N 18-4384N269TCleveland Frank W · Quinhagak, AKBuilt 1953 · S/N 18-2383N26VCAlbertson James M · Westville, FLS/N 18-2328N27036Pace William Todd · Palmer, AKS/N 18-3516
Back to AD 72-01-07