OpenAirDocs.org
AD 2002-21-13

Registered aircraft · 579

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:2002-21-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:2002-21-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.

N8861ABehnke Jonathan D · Gilbert, AZBuilt 1950 · S/N D-2506N8865AJackson Robert K · Bay City, TXBuilt 1950 · S/N D-2520N8867AThorson William D · Las Vegas, NVBuilt 1950 · S/N D-2522N8883ALambson Roger S · Saint Ignatius, MTBuilt 1950 · S/N D-2538N8890ALangley Troy C · Newport, WAS/N D-2545N8893ATurbine Financial Group LLC · Ogden, UTBuilt 1950 · S/N D-2591N8900AHooker Robert Edwin · Hamer, SCBuilt 1950 · S/N D-2598N8905AGalliart Herb · Anthony, NMFirst renewal noticeBuilt 1950 · S/N D-2603N8906APierce Phillip · Ashville, ALBuilt 1950 · S/N D-2604N8908AMclenaghan Alvin N · Phoenix, AZBuilt 1950 · S/N D-2606N8910AAllison Loyd M · Molt, MTBuilt 1950 · S/N D-2608N8911ABeverage Jamie L · Crescent, OKBuilt 1950 · S/N D-2662N8917ARosenkranz Rashell Denning · Ellensburg, WABuilt 1950 · S/N D-2617N8924AIrion Thomas J · Livermore, CABuilt 1950 · S/N D-2624N8925ATaylor Ernest N Jr · Doral, FLBuilt 1950 · S/N D-2625N8926AEllington William E Jr · Houston, TXS/N D-2626N8927ANatale Julian K · Wakefield, RIBuilt 1950 · S/N D-2627N90575Benschoter Cameron Paulk · Jonesboro, GAFirst renewal noticeBuilt 1948 · S/N D-1848N908WTPrice James E · Reno, NVS/N D-926N910JLHuska Trey K · Kingston, WAS/N D-850N911DMPort Townsend Aero Museum · Port Townsend, WABuilt 1947 · S/N D-1118N920MSale Reported · Homestead, FLSale reportedBuilt 1947 · S/N D-147N963SMNydam Scott A · Newport News, VAS/N D-1289N964THBeck Roger M Trustee · Goode, VAS/N D-2116N969PAdams Dirk L · Pleasant Hill, OHBuilt 1947 · S/N D-71N99JGrubbs Terry · Gregory, SDBuilt 1947 · S/N D-165N99QR W Zollinger Consulting Engineers Inc · Moon Township, PABuilt 1947 · S/N D-277N9ALoughrey Gary T · Queensbury, NYBuilt 1947 · S/N D-523N9VDFruguglietti Joseph Matthew · Burney, CABuilt 1947 · S/N D-467
Back to AD 2002-21-13