AD 97-01-13

Registered aircraft · 54,837

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:97-01-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
  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.

N18050Jarrell Loyd F · Whitesburg, TNBuilt 1972 · S/N 15073759N18052Sky Views LLC · Mount Crawford, VABuilt 1972 · S/N 15073760N18053Kraft Tyrone H · Timber Lake, SDBuilt 1953 · S/N 30548N18055Plane Fun Inc Tr Trustee · Snellville, GABuilt 1955 · S/N 31463N18057Palmer Jedidiah J · Lewiston, IDS/N 15073763N18061Foster Rodney D · Quanah, TXBuilt 1972 · S/N 15073765N18067Get Out Aviation LLC · Palmer, AKS/N 15073769N18069Olandese Donald J · Newalla, OKBuilt 1972 · S/N 15073771N1806RFly By Night Aviation Inc · Pleasantville, NYBuilt 1978 · S/N R18200565N1806XBrowning Lonnie O IV · Allendale, SCS/N 18255906N1806YMadcity Aviation LLC · Madisonville, KYBuilt 1962 · S/N 17249406N18071Rock River Aviation · Watertown, WIBuilt 1972 · S/N 15073773N18075Northwestaildraggers LLC · Washougal, WABuilt 1975 · S/N 18052511N18076Angelos Mark A · Concord, CAS/N 15073776N1807RVeldman Richard D · Laporte, INBuilt 1978 · S/N R18200566N18081Eyes Above LLC · Hampton Falls, NHBuilt 1972 · S/N 15073780N18088Durin Steven C · Steward, ILS/N 15073784N1808XM&M Land Company LLC · Marietta, OHBuilt 1964 · S/N 18255908N1808YHardy Russell L · Rimrock, AZBuilt 1962 · S/N 17249408N1808ZFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVNon-citizen corporation, flight hours not reportedBuilt 1962 · S/N 205-0008N1809MSkymaster-173 LLC · New Bern, NCBuilt 1971 · S/N 33701409N1809XMilburn Thomas D Trustee · Lompoc, CABuilt 1964 · S/N 18255909N1809ZCleared For Departure LLC · Kennewick, WABuilt 1962 · S/N 205-0009N180AHigginbottom Nathan · Cave City, ARBuilt 1954 · S/N 31090N180AAButler Tracey D · Buckley, WABuilt 1973 · S/N 18052399N180ABFoster Bradley J · Wichita, KSBuilt 1953 · S/N 30210N180AFRegistered aircraftBuilt 1957 · S/N 32809N180AGAg Leasing LLC · Wilmington, DES/N 18052187N180AHSwiss Arctic Flyers Inc · Lewes, DEBuilt 1981 · S/N 18053192N180AKBecker Kurt G · Dexter, NMBuilt 1955 · S/N 31349N180ANJones Marvin B · Farmerville, LABuilt 1957 · S/N 50008N180APAir Plains Services Corp · Wellington, KSBuilt 1965 · S/N 18051472N180AQTracy Michael R · Santee, CABuilt 1967 · S/N 18051848N180AXNoyes Abigail · North Pole, AKBuilt 1969 · S/N 18051910N180AYPerkins Paul Fortaine · Anchorage, AKS/N 50052N180AZMohr Elizabeth G · Brandon, MSBuilt 1974 · S/N 18052433N180BADavis Robert D · Camas, WAS/N 18052419N180BBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18053103N180BDSanderson Bryan D · Emmett, IDBuilt 1954 · S/N 30848N180BFComunale Anthony S · Roxbury, CTBuilt 1973 · S/N 18052402N180BGCmw Aircraft LLC · Hailey, IDS/N 31372N180BHMorris Christopher H · Valparaiso, INS/N 18052132N180BKKrissman Ryan · Gallup, NMBuilt 1970 · S/N 18052120N180BRDainas Barry · Port Orange, FLBuilt 1955 · S/N 31386N180BSSerie Dennis P · Chugiak, AKBuilt 1959 · S/N 624N180BTAerobug LLC · League City, TXBuilt 1967 · S/N 18051815N180CBrown Hector M · Glenwood Springs, COBuilt 1956 · S/N 32312N180CBSmith Dennis A Trustee · Salem, ORBuilt 1955 · S/N 31489N180CDHicks P David · Heber City, UTS/N 18052310N180CETailwinds Ranch LLC · Orlando, FLBuilt 1976 · S/N 18052669
Back to AD 97-01-13