AD 72-02-01

Registered aircraft · 282

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-02-01')
    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-02-01')
  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.

N234DADestination Management LLC · Tulsa, OKBuilt 1971 · S/N 421B0122N238FALetourmeau University · Longview, TXBuilt 1972 · S/N 421B0238N239SERiley Charles Sweeney · Highlands Ranch, COBuilt 1972 · S/N 421B0315N23DTAlastrom Aviation LLC · Wilmington, DEBuilt 1975 · S/N 421B0852N240RTAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1975 · S/N 421B0863N241TSGrey Matter Inc · Valley Springs, CAS/N 421B0110N242HB2hb Airways LLC · Saint Louis, MOBuilt 1970 · S/N 421B0049N251WWEbbert Thomas E DBA · Gary, INRegistration revokedBuilt 1967 · S/N 411-0251N25FERound Trip Lc · Elkhart, KSS/N 421-0055N269FAir2615 LLC · Wilmington, DEBuilt 1968 · S/N 421-0177N2836DSale Reported · Yucaipa, CASale reportedBuilt 1966 · S/N 411-0190N285NTotem Air Inc · Seattle, WABuilt 1968 · S/N 421-0169N28835Waddingham William B · Rancho Cucamonga, CABuilt 1969 · S/N 421A-0050N2957QGenerals International Inc · Red Oak, TXBuilt 1969 · S/N 421A0057N2979SAerospace Trust Management LLC Trustee · Wilmington, DES/N 4110272N300MBIglesia De Cristo · Porter Ranch, CABuilt 1974 · S/N 421B0573N304MCValiair Lc Trustee · Casper, WYS/N 421B0130N315MDuckwing LLC · Reno, NVS/N 421B0107N318PPK&A Consulting Of Montana Inc · Billings, MTBuilt 1974 · S/N 421B0843N318TWFlg Air Transport LLC · Miramar, FLS/N 421-0170N31KCWashington State Community College · Spokane, WABuilt 1973 · S/N 421B0344N31KSPaxton Jacob · Killeen, TXS/N 421B-0662N31KTSmith Kenneth L · Pomona, CABuilt 1970 · S/N 421B0011N321HASkytook LLC · Wilmington, DEBuilt 1973 · S/N 421B0420N333CJDrj Aviation LLC · Dover, DEBuilt 1972 · S/N 421B0313N333KWD G R Air LLC · Braselton, GABuilt 1974 · S/N 421B0657N333SFFerretti James L III · Port Orange, FLBuilt 1967 · S/N 411-0260N3377QMendez Jr Leo · Corpus Christi, TXS/N 421B0261N3398QRiebe Grover C Jr · Gwinner, NDBuilt 1969 · S/N 421A0108N3540MDybel William P · Frankfort, ILS/N 421B0472N355RTBeechwood Aviation LLC · Wilmington, DEBuilt 1974 · S/N 421B0633N35FSSelistli LLC · San Mateo, CABuilt 1974 · S/N 421B0831N37676Campbell & Associates Investment Properties LLC · Burleson, TXBuilt 1974 · S/N 421B0584N37JKSsr LLC · Incline Village, NVS/N 421B0934N37MBresciani Martin · Guaynabo, PRS/N 421B0805N382MCShiver James B · Stanley, NMS/N 421B0452N384AMHaggard Haley G · Springer, OKS/N 421B0304N400BJAirrich LLC · Largo, FLBuilt 1974 · S/N 421B0819N400CEMcmurray Bradley Thomas · Advance, NCBuilt 1975 · S/N 421B0930N400TMPaxton Homes LLC · Killeen, TXS/N 421B0885N4070LDesert Air LLC · Hagerman, NMBuilt 1968 · S/N 421-0070N4074LEminent Technology · Tallahassee, FLBuilt 1968 · S/N 421-0074N40JCDbs Aviation LLC · Sulphur Springs, TXBuilt 1973 · S/N 421B0384N41019Sjs Flights Lp · Columbus, GABuilt 1973 · S/N 421B0401N41041Mathews Christopher D · Blue Earth, MNBuilt 1973 · S/N 421B0412N41055J&B Aircraft LLC · Anaheim, CABuilt 1974 · S/N 421B0576N41085421 Bravo LLC · Marine City, MIS/N 421B0440N410ECSoutheast Enterprises LLC · Dothan, ALBuilt 1973 · S/N 421B0422N41106Delorenz Robert J · Boca Raton, FLBuilt 1974 · S/N 421B0589N41114Iacobacci Timothy R · Fairborn, OHBuilt 1973 · S/N 421B0458
Back to AD 72-02-01