OpenAirDocs.org
AD 89-24-01 R1

Registered aircraft · 4,242

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

N6700PAbraham Curtis · Byron, WYBuilt 1978 · S/N P21000200N6709QClear Blue Marketing Inc · Reno, NVBuilt 1983 · S/N EA-368N6715RRose Mary R · Portland, ORBuilt 1966 · S/N T210-0115N671TCBraunstein Robert S · Seattle, WABuilt 2001 · S/N EA-671N67224Vx Inc · Burbank, CABuilt 1983 · S/N EA-370N6722BJca Aviation LLC · Safford, AZS/N 21062826N6728FPeters Bruce L · Wichita, KSBuilt 1983 · S/N EA-379N6728RRegency Horizons Group LLC · Middletown, DEBuilt 1983 · S/N EA-380N6728ZMccrorie LLC · Helena, MTBuilt 1980 · S/N EA-57N672HBValiair Ltd Co Trustee · Casper, WYBuilt 1977 · S/N 340A0324N6731ZJerry Slough Aviation LLC · Bakersfield, CAFirst renewal noticeBuilt 1980 · S/N TJ-255N6733MWilson Lawrence J · West Sacramento, CABuilt 1979 · S/N EA-37N6734UR E Bentz Inc · Monroe, LAS/N TK-117N6736TBrakke Thomas · Clear Lake, IABuilt 1981 · S/N EA-242N6737VRiverview Ranches · Chowchilla, CAS/N EA-63N6739CPearce William · Grants Pass, ORBuilt 1980 · S/N TJ-262N673DKBh Aero LLC · Hanover, MNBuilt 1979 · S/N 21063479N673TBalchunas Anthony B · Robinson, TXBuilt 1967 · S/N D-8470N6741MCooper Aviation LLC · Georgetown, SCBuilt 1980 · S/N TK-122N6745YSeamech International Inc · Houston, TXBuilt 1984 · S/N EA-401N6746RSchwartz Daniel T · Meeker, COBuilt 1966 · S/N T210-0146N6748CSan Andres Farms · Raymondville, TXBuilt 1980 · S/N EA-76N6748VCannon Oil & Gas Well Services Inc · Rock Springs, WYBuilt 1980 · S/N TK-120N674PCLegal Wings I LLC · Overland Park, KSBuilt 1978 · S/N 340A0544N6750VSouth Delta Aviation Inc · West Helena, ARS/N TJ-275N6752XIyer Vijay · Mammoth Lakes, CABuilt 1980 · S/N TJ-276N6753HJsy Aviation LLC · Port Angeles, WABuilt 1983 · S/N EA-395N67586Carwashos LLC · Colorado Springs, COBuilt 1983 · S/N EA-397N6758XAc Green LLC · Athens, OHBuilt 1980 · S/N TK-134N6759RRegistered aircraftS/N T210-0159N675RVb Flying LLC · Cornelius, NCBuilt 1981 · S/N 414A0634N6765THyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0629N67664Hukill Ryan R · Eagle Point, ORS/N 340A1534N67799Piper Arrow LLC · Yarmouth, MEBuilt 1984 · S/N EA-433N6779BRegistered aircraftBuilt 1978 · S/N 21062829N677CAHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0631N6787RJensen Leland · Idaho Falls, IDBuilt 1966 · S/N T210-0187N67886Hyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0435N6789YMcdonough Patrick J · Defiance, OHBuilt 1986 · S/N EA-453N678CTSanborn Thomas W · College Station, TXBuilt 1978 · S/N P21000019N678HDawson Aircraft Inc · Clinton, ARBuilt 1981 · S/N 414A0678N678HCMckisson Holdings LLC · Renton, WABuilt 1980 · S/N EA-180N678JSGolden Pegasus LLC · Hughson, CABuilt 1978 · S/N 414A0090N67909Hyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0449N67CHPrestige Aviation LLC · Lake Havasu City, AZBuilt 1981 · S/N 21064354N67DFSusens Dennis W · Columbia Falls, MTBuilt 1998 · S/N 98191N67EPViner Kevin Patrick · Encinitas, CAS/N P21000032N67ERWhitfield Michael L · Leander, TXBuilt 1976 · S/N TJ-43N67RKRiley Matthew · Xenia, OHS/N 310Q1107N67RZModular Aviation LLC · Saratoga Springs, UTBuilt 1981 · S/N 414A0817
Back to AD 89-24-01 R1