AD 2022-08-13

Registered aircraft · 3,069

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:2022-08-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:2022-08-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.

N151CLAircraft Structures International Corp · Enid, OKBuilt 1988 · S/N 208B0083N1520QBrekhus Julius P · Kenmare, NDBuilt 1991 · S/N 402-0838N15210O'Hare R Mike · Clovis, NMBuilt 1991 · S/N 402-0840N1529ERoth Aerial Spraying LLC · Milford, NEBuilt 1991 · S/N 502-0161N1529HMiller Aviation Inc · Norton, KSBuilt 1992 · S/N 502A-0158N1529USnider Scott E DBA · Turner, MTBuilt 1992 · S/N 402-0849N152ALN152al LLC · Tulsa, OKBuilt 2004 · S/N 4697182N1531GWoodley Aerial Leasing LLC · Walnut, ILBuilt 1992 · S/N 402-0850N1531SWakefield Aircraft LLC · Cooperstown, NDBuilt 1991 · S/N 802-0002N1533SMj Aviation Inc · Walnut Ridge, ARBuilt 1991 · S/N 402-0847N1539XRba LLC · Kimberly, IDBuilt 1992 · S/N 502A-0166N153GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-153N153KDMec International Trading LLC · Mission, TXBuilt 1968 · S/N 153N153PBCarojake LLC · Spartanburg, SCBuilt 1996 · S/N 153N1540SArthur Aviation LLC · Arthur, NDBuilt 1992 · S/N 502-0171N1544VGuardian Flight LLC · Lewisville, TXBuilt 1994 · S/N LJ-1366N1547UR & D Leasing Inc · Lemoore, CABuilt 1992 · S/N 502A-0183N154CAFedair Inc · Indianapolis, INBuilt 1980 · S/N 31T-8020085N154CLAircraft Structures International Corp · Enid, OKBuilt 1990 · S/N 208B0212N154GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-154N154NPSisk Douglass F Trustee · Oakhurst, CABuilt 2019 · S/N 100-0262N1552DDodson International Parts Inc · Rantoul, KSBuilt 1989 · S/N LJ-1204N1552GEast Atlantic Aviation LLC · Edenton, NCBuilt 1989 · S/N LJ-1206N1553GMccloy Mark · Tatum, NMBuilt 1989 · S/N LJ-1214N1556WPrecissi Flying Service Inc · Lodi, CAFirst renewal noticeBuilt 1992 · S/N 502-0185N15570Shearer Sprayers Inc · The Dalles, ORBuilt 1992 · S/N 402-0884N15588Slikker Flying Service Inc · Buttonwillow, CABuilt 1992 · S/N 502A-0175N1558URba LLC · Kimberly, IDBuilt 1992 · S/N 502A-0188N155CJUe-55 LLC · Helena, MTS/N UE-55N155CLAircraft Structures International Corp · Enid, OKBuilt 1988 · S/N 208B0127N155KQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 100-0155N155MCWhite Bay Aviation LLC · Corpus Christi, TXBuilt 1978 · S/N 31T-7820069N155SYRocky Mountain Aviation LLC · Aberdeen, IDBuilt 1992 · S/N 1013N155VVVolatile Aero Ventures LLC · Boulder City, NVBuilt 2009 · S/N 155N157CLSnowy Butte Air Ships LLC · Eagle Point, ORBuilt 2015 · S/N 100-0157N157HJaars Inc · Waxhaw, NCBuilt 2020 · S/N 20800668N157LAWakefield Aircraft LLC · Cooperstown, NDBuilt 2003 · S/N 802A-0157N157MHMile Hi Skydivers Inc · Longmont, COS/N LW157N157STAllen Family Aviation LLC · Haines, ORBuilt 2023 · S/N 4698280N158CLUnited States Government · Fort Belvoir, VABuilt 1981 · S/N 58N158KQGuardian Angel Homes LLC · Hayden, IDBuilt 2015 · S/N 100-0158N159CMMomentum Foundation Inc · Tullahoma, TNBuilt 1987 · S/N 760333N160KQMjolhus Knut G · Amarillo, TXBuilt 2015 · S/N 100-0160N160RWRitch Air LLC · Visalia, CABuilt 1998 · S/N FL-226N160SMAviation Star S LLC · Beaumont, TXBuilt 1998 · S/N FL-215N160ZUsda Forest Service · Boise, IDBuilt 2017 · S/N 100-0227N161KQPenridge Aviation LLC · Portland, ORBuilt 2015 · S/N 100-0161N162GAPa1 208b-0667 LLC · Fort Lauderdale, FLBuilt 1998 · S/N 208B0667N162MCBank Of Utah Trustee · Salt Lake City, UTS/N B137N162QMartin Foundry Service Inc · Glencoe, ALBuilt 1982 · S/N BB-1104
Back to AD 2022-08-13