OpenAirDocs.org
AD 61-20-02

Registered aircraft · 1,222

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

N101DHLarson David R · Boerne, TXBuilt 1960 · S/N 24-1833N106JLinder Michael A · Arvada, COBuilt 1961 · S/N 24-2668N1070BCurtis Julia A · Holladay, UTBuilt 1964 · S/N 24-3620N108SGVahsholtz Matthew James · Conroe, TXBuilt 1958 · S/N 24-149N10NWLinzey David Wayne · Boone, NCBuilt 1963 · S/N 24-3548N10SGBranyan Tyson E · Cushing, OKBuilt 1960 · S/N 24-2112N110LFComanche Flyer Foundation Inc · Blaine, WAS/N 24-695N11151Kowest Aviation LLC · Enid, OKBuilt 1959 · S/N 24-1631N111LFZimmerman Leland · Center, COBuilt 1959 · S/N 24-1023N111SLKaehlert Lottie DBA · Rifle, COS/N 24-2532N112WSEdgeington Randall K · Riverton, WYBuilt 1961 · S/N 24-2765N114XTaft Plumbing Co Inc · Taft, CABuilt 1961 · S/N 24-2698N120SGlenn Robert · Boulder, COBuilt 1958 · S/N 24-125N12134Everson Corey A · Madison, ALBuilt 1964 · S/N 24-3598N1223Munning Joseph H Md · Jasper, INBuilt 1961 · S/N 24-2906N123HMComanche Air LLC · Mokena, ILBuilt 1961 · S/N 24-2912N12RDFlying Colors Airparts Inc · Leesburg, FLBuilt 1958 · S/N 24-368N142CATack Kenneth W · Taft, CABuilt 1959 · S/N 24-1161N1440XAlldredge Brad · Redlands, CABuilt 1963 · S/N 24-3478N146PWilliams Mike C · Sonora, TXS/N 24-366N14FCJwc59 LLC · Newnan, GABuilt 1959 · S/N 24-924N14YPHubbard Scott Edward Jr · Deatsville, ALBuilt 1962 · S/N 24-3246N156DCEaton Billy J · Bridgeport, TXBuilt 1961 · S/N 24-2751N161PRegistered aircraftBuilt 1958 · S/N 24-533N16DPNdmi Inc · Greeneville, TNS/N 24-3024N17TARetired Aviators Flying Club LLC · Oklahoma City, OKBuilt 1961 · S/N 24-2652N1901PTurner William D · Southaven, MSBuilt 1958 · S/N 24-183N1959PTanner Greg L · Bend, ORBuilt 1959 · S/N 24419N1XACowell Aviation Maintenance LLC · Easley, SCBuilt 1964 · S/N 24-3599N200DBDelta Bravo Inc · Davie, FLBuilt 1959 · S/N 24-1080N212GPWibel Enterprises Inc · Crossville, TNS/N 24-3327N212RGGillum Reef · Clint, TXBuilt 1962 · S/N 24-3123N2172MPacker Bruce P Trustee · Tempe, AZBuilt 1963 · S/N 24-3305N218SAInternational Air Services Inc Trustee · Carson City, NVS/N 24-1877N221DFMoeckel Herbert R · Tunas, MOBuilt 1958 · S/N 24-242N2222ZParsons John C · Wichita, KSBuilt 1963 · S/N 24-3388N222HLDouble K Flying LLC · Scottsboro, ALBuilt 1961 · S/N 24-2670N224KJam Three LLC · St George, UTBuilt 1959 · S/N 24-1609N226MAdams Larry Gene · Parker, AZBuilt 1960 · S/N 24-2326N228FPRegistered aircraftS/N 24-2538N229TYSchilling Aviation LLC · Britton, MIBuilt 1962 · S/N 24-3339N22TKGreen Theodore G · Franklin, WIBuilt 1963 · S/N 24-3541N232YPGill Joshua Daniel · Tucson, AZS/N 24-3401N23LGGist Thomas Hottel III · Little Rock, ARBuilt 1959 · S/N 24-832N250CCAerodynamics Worldwide Inc · Wilmington, DEBuilt 1960 · S/N 24-1931N250GTComanche Golf Tango LLC · Clifton, VAS/N 24-2496N250LJCarew Aviation Inc · Appleton, WIBuilt 1964 · S/N 24-3393N250PCHerndon Timothy M · Kingston, OKBuilt 1959 · S/N 24-1133N250RBWestern Slope Aviators LLC · Delta, COBuilt 1958 · S/N 24-334N250TJTalley John T · Clifton, TXBuilt 1959 · S/N 24-1048
Back to AD 61-20-02