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.

N1451Shaughnessy Thomas E · Seabrook, NHBuilt 1953 · S/N 18-2259N1456CBrewer Alfred D · Hillsboro, ORBuilt 1953 · S/N 18-2654N1458CKohlhase Kent E · Anchorage, AKBuilt 1953 · S/N 18-2657N145CSchmitt Mark R · Rockford, MIBuilt 1954 · S/N 18-3335N1460CMaki Tim J · Hibbing, MNBuilt 1953 · S/N 18-2659N1466CBent James L Jr DBA · Palatine Bridge, NYS/N 18-2668N1467CWeflen Arvid W · Fairbanks, AKBuilt 1953 · S/N 18-2682N146THanson Brady W · Soldotna, AKBuilt 1952 · S/N 18-2260N1470CHillestad Darrell L · Aberdeen, SDBuilt 1953 · S/N 18-2670N1471CNorris Cathy J · Statesville, NCS/N 18-2673N1473CGo Aviation Inc · Potsdam, NYBuilt 1953 · S/N 18-2677N1474CSweeney Brett D · Anchorage, AKBuilt 1953 · S/N 18-2678N1476CAsher Debra L · Wasilla, AKBuilt 1953 · S/N 18-2681N147TScrobola James M · Wyoming, PABuilt 1953 · S/N 18-2261N148TRegistered aircraftBuilt 1953 · S/N 18-2262N1493CH G Klug Sons Inc · Omaha, NEBuilt 1953 · S/N 18-2687N1500JBent James L Jr DBA · Palatine Bridge, NYS/N 18-294N1500PBent James L Jr DBA · Palatine Bridge, NYS/N 18-3672N150CWCleveland William L · Lander, WYS/N 18-4329N150TTowe Lannie K · Madison, ALBuilt 1953 · S/N 18-2264N1532VSutton Aviation LLC · Maunaloa, HIBuilt 1950 · S/N 18-572N154TKornchuk Kurt C · Wasilla, AKS/N 18-2268N1551PPhillips Kris D · Cordova, AKBuilt 1954 · S/N 18-3704N1552PErickson James M · Wasilla, AKS/N 18-3705N1554PPerkins Michael D Trustee · Bigfork, MTBuilt 1954 · S/N 18-3709N15558Nighthawk Air Systems Inc · Marion, TXS/N 18-3876N1557PVlasic Steven Robert · Homer, AKBuilt 1954 · S/N 18-3711N1559PSnatchaday LLC · Carabaset Vly, MEBuilt 1954 · S/N 18-3716N1560PGoodnight James J · Salisbury, NCBuilt 1954 · S/N 18-3717N1563PShoemaker Tia M · Wasilla, AKBuilt 1954 · S/N 18-3722N1565PPott David F · Fairbanks, AKBuilt 1954 · S/N 18-3726N156TSale Reported · Casselton, NDSale reported, canceledBuilt 1953 · S/N 18-2270N157TMccray B F Jr · Manchester, OKBuilt 1953 · S/N 18-2271N1580PBltyhe Anne T · Paso Robles, CAS/N 183743N1588PWar Eagles Air Museum · Santa Teresa, NMBuilt 1954 · S/N 18-3751N1590PForgey Carl · Petersburg, AKBuilt 1954 · S/N 18-3755N1592PFerguson Robert C · Cornelia, GABuilt 1954 · S/N 18-3757N1596PPassmore Aviation LLC · Claremore, OKS/N 18-3761N1597PStokes Letta J · Chugiak, AKBuilt 1954 · S/N 18-3762N1599PSnowden Robert W · Mason, TXBuilt 1954 · S/N 18-3764N159TGumley Titus G · Wasilla, AKBuilt 1953 · S/N 18-2273N15XXDalks Leasing Inc · Wilmington, DEBuilt 1951 · S/N 18-811N1602ABent James L Jr DBA · Palatine Bridge, NYS/N 18-1240N1604AFredericks Elmo J · Mandaree, NDBuilt 1951 · S/N 18-1242N160CWAbraham Elizabeth J · Browntown, WIBuilt 1950 · S/N 18-343N1610ABauder Robert J · Soldotna, AKBuilt 1951 · S/N 18-1252N1611AJones William Ransom · Anchorage, AKBuilt 1951 · S/N 18-1251N1611CNorthern Flyway LLC · Anchorage, AKBuilt 1954 · S/N 18-3393N1612AGlover Thomas B · Marana, AZS/N 18-1253N1620ABeaver David W Trustee · Wasilla, AKBuilt 1952 · S/N 18-1263
Back to AD 72-01-07