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.

N1887AErickson Paul F · Wasilla, AKS/N 18-1725N1888AAlaska Tailwheel LLC · Fairbanks, AKBuilt 1952 · S/N 18-1718N1890AJohnson Air LLC · Anselmo, NEBuilt 1952 · S/N 18-1723N1891AEntriken Birch N · Reno, NVFirst renewal noticeBuilt 1952 · S/N 18-1891N1892ALesmeister Dean J · Kindred, NDBuilt 1952 · S/N 18-1726N1896AHudson Jared M · Anchorage, AKBuilt 1952 · S/N 18-1728N189TNew London Taildraggers · Lynchburg, VABuilt 1953 · S/N 18-2303N18GEHorvitz Martha E · Poway, CABuilt 1950 · S/N 18-227N18JZAcv Group LLC · Mckinleyville, CAS/N 18223N18LJKallam Jerry C · Palmer, AKFirst renewal noticeBuilt 1960 · S/N 18-7584N18SNSmiley Stephen P · Canandaigua, NYBuilt 1955 · S/N 18-3966N18YHBaker Property Management · Indian Valley, IDS/N 7585N18ZFReel Chad A · Wasilla, AKBuilt 1951 · S/N 18-1159N18ZZGardom Brandon D · Spirit Lake, IDBuilt 1959 · S/N 18-3380N1906AHoyer Larry B · Fort Peck, MTBuilt 1952 · S/N 18-1739N1911ADay Patrick J · Bloomer, WIBuilt 1952 · S/N 18-1745N1912AWebber David A · Delta Junction, AKBuilt 1952 · S/N 18-1748N1914AElmore James C Jr · Hedgesville, WVBuilt 1952 · S/N 18-1751N1919AHolman Terence A · Portland, ORBuilt 1952 · S/N 18-1747N1927AHigh Wind Aviation Services LLC · Ludlow, VTBuilt 1952 · S/N 18-1762N1930ABoyer Jason Allen · Kasilof, AKS/N 18-1768N1934ASlayden Steven M · Rhome, TXBuilt 1952 · S/N 18-1769N1939ACasabonne Family Ltd Partnership · Hope, NMBuilt 1952 · S/N 18-1773N193TBurmeister Aaron · Nenana, AKS/N 18-2307N194TNicholson Earl J · New Milton, WVBuilt 1953 · S/N 18-2308N1950PJefferies R Wayne · Durango, COFirst renewal noticeBuilt 1955 · S/N 18-4176N1950YCostanza Joseph Vincent · Marlton, NJBuilt 1950 · S/N 18-191N1952PWinterton Gary S · Lindon, UTBuilt 1955 · S/N 18-4178N1953MFugate Terry L · Atoka, OKS/N 182998N1953VAarestad Potato Co Ltd · Hillsboro, NDBuilt 1952 · S/N 18-2174N1957ASkywagon Aero LLC · Wilmington, DEBuilt 1952 · S/N 18-1795N1959AWhite B Scott · Castlewood, VAFirst renewal noticeBuilt 1952 · S/N 18-1801N195THandyside Bryan P · Duluth, MNBuilt 1953 · S/N 18-2309N1968PWygant Michelle R · Copper Center, AKBuilt 1957 · S/N 18-4200N1983PCarlson Andrew J · Ashville, NYBuilt 1955 · S/N 18-4218N1984ASuper D Group LLC · Hanoverton, OHBuilt 1952 · S/N 18-1808N1988ABroussard Lewis A Jr · Morse, LABuilt 1952 · S/N 18-1813N1991AHolman Daily A · Canby, ORBuilt 1952 · S/N 18-1815N1994AHuppert Gerald P · Palmer, AKBuilt 1952 · S/N 18-1816N2014PAerial Sign North · Lakewood, NJBuilt 1956 · S/N 18-4602N202TMurray James A · Wasilla, AKBuilt 1953 · S/N 18-2316N203TProfota Don L · Bozeman, MTBuilt 1953 · S/N 18-2317N204TTFalkenberg Randy J · Edmonson, TXBuilt 1952 · S/N 18-2318N205TClark Stephen N · Walnut Cove, NCBuilt 1953 · S/N 18-2319N206TSchou Brice N · Thomas, OKBuilt 1953 · S/N 18-2320N20821Danielson Robert DBA Conventional Air · Decatur, MIBuilt 1954 · S/N 183547N2102VGiovanini Terry L · Bozeman, MTBuilt 1954 · S/N 182663N2113ASale Reported · Glasgow, MTSale reportedS/N 18-1844N2115AJj Ventures LLC · Billings, MTBuilt 1952 · S/N 18-1846N2124NLivestock Service Inc · Douglas, AZBuilt 1951 · S/N 18-259
Back to AD 72-01-07