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.

N1627APlettner David C · Sutton, NEBuilt 1951 · S/N 18-1267N1636AHilliard John · Olympia, WABuilt 1952 · S/N 18-1281N163TKloes Michael L · Everett, WABuilt 1953 · S/N 18-2277N1650PChilcote Gary D · Britt, MNBuilt 1954 · S/N 18-3765N1651PCaron Ty · Redmond, ORBuilt 1954 · S/N 18-3766N1652PCcf Ventures Inc · Bangor, MEBuilt 1954 · S/N 18-3767N1653PAirmotive Service LLC · Brigham City, UTBuilt 1954 · S/N 18-3768N1658PSmith Gregory · Lewistown, MTBuilt 1954 · S/N 18-3780N165TGrove Robert P · El Cajon, CABuilt 1953 · S/N 18-2279N1662PRyan Dietrich Farms Inc · Scottsbluff, NEBuilt 1954 · S/N 18-3784N16688Water Wings LLC · Buckley, WAS/N 18-875N166TBuechle Tim P · Talkeetna, AKBuilt 1953 · S/N 18-2280N167TTouchstone Gwendolyn M · Villa Rica, GABuilt 1953 · S/N 18-2281N1701ACirri Joseph A · Deming, NMBuilt 1952 · S/N 18-1288N17080Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1959 · S/N 18-7196N170TStoltzfus Sandra · Kidron, OHBuilt 1945 · S/N 18-2284N172TMissaukee Aircraft Leasing LLC · Cadillac, MIBuilt 1953 · S/N 18-2286N1738ALyall Gregory S · Anchorage, AKS/N 18-1311N1754ASchrock Jaden D · Sterling, AKS/N 18-1319N1754PLorring Eric H · Kodiak, AKS/N 18-4074N1755ASchultheis John U · Wasilla, AKBuilt 1952 · S/N 18-1314N1759AHargus Betty R · Fort Stockton, TXS/N 18-1325N1765PHendry Robert L · Lysite, WYBuilt 1954 · S/N 18-4090N1783ASatra Jerry · Savage, MTBuilt 1952 · S/N 18-1328N1788ADavis Nigel L · Helena, MTBuilt 1952 · S/N 18-1658N1793AHickle Lucas · Wasilla, AKS/N 18-1664N1795ASvendsen Gregory Roy · Anchorage, AKBuilt 1952 · S/N 18-1665N1798ASlow Goose LLC · Chevy Chase, MDBuilt 1952 · S/N 18-1667N180TWatanabe Masayuki · Harbor Oaks, FLBuilt 1953 · S/N 18-2294N18141Schulte James P · Hurst, TXBuilt 1951 · S/N 181332N181AWKustatan Leasing LLC · Nikiski, AKS/N 18-1743N181TWatkins Steven B · Roxboro, NCBuilt 1953 · S/N 18-2295N1820ACaley Robert M · Green, KSBuilt 1952 · S/N 18-1671N1829AMcelligott Joseph P · Ione, ORBuilt 1952 · S/N 18-1679N1841AJohnson Kevin L · Canyon, TXBuilt 1952 · S/N 18-1735N1850AWells Kris G · Barron, WIBuilt 1952 · S/N 18-1684N1852PBennack George H · Lyford, TXBuilt 1955 · S/N 18-4101N1853DBent James L Jr DBA · Palatine Bridge, NYS/N 18-53N1855AMoore Brandan D · Wasilla, AKBuilt 1952 · S/N 18-1681N1857PJanvrin Jerry M · Buffalo, SDBuilt 1955 · S/N 18-4124N1858ALow And Slow LLC · Bozeman, MTBuilt 1953 · S/N 18-1686N1861ABernstein Timothy D · Faith, SDS/N 18-1691N186TKing George W · Strykersville, NYBuilt 1953 · S/N 18-2300N1871ASkywagon Aero LLC · Wilmington, DES/N 18-1703N1876AKalarney Kerry T · Olathe, COBuilt 1952 · S/N 18-1712N1878ANapa Taildraggers Inc · Napa, CAS/N 18-1713N1878PLutter Jim L · Gann Valley, SDS/N 18-4157N1879ASale Reported · Eagle River, AKSale reported, pending cancellationS/N 18-1711N1882PAir Dakota Flite Inc · Hettinger, NDBuilt 1955 · S/N 18-4163N1886AGriffith Richard B · Sycamore, ILBuilt 1952 · S/N 18-1719
Back to AD 72-01-07