OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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

N348SKoritz Iowa Properties LLC · Key Colony Beach, FLBuilt 1970 · S/N D-9125N348TFli Aero Ltd · New Lebanon, OHBuilt 1976 · S/N E-908N3490BSchable Roland J · Janesville, WIBuilt 1954 · S/N D-3710N3491BHinkle Airspray Inc · Cavalier, NDBuilt 1954 · S/N D-3711N3495BGerhardt James L · Owasso, OKBuilt 1954 · S/N D-3713N3499BRegistration Pending · Perkins, OKRegistration pending, pending cancellationBuilt 1954 · S/N D-3717N349RPMiranda Gary R · Vancouver, WABuilt 1998 · S/N E-3202N349YVam Aviation LLC · Edmond, OKBuilt 1962 · S/N TC-389N34AFHangar 6 Aviation LLC · Destin, FLBuilt 1954 · S/N 34-51N34AQZimmerman Steven W · Olathe, KSBuilt 1956 · S/N CG112N34ATField Kent · Santa Barbara, CABuilt 1957 · S/N G-139N34BAPrvny Pluk LLC · Houston, TXBuilt 1956 · S/N G-797N34BRIndustrial Reports Inc · Raleigh, NCBuilt 1981 · S/N CE-946N34BVDessuit Franklin Jr · Mckinney, TXBuilt 1956 · S/N CG-152N34BWMaintenance Forecasters Inc · Falmouth, MIBuilt 1974 · S/N TC-1691N34BZDimich Milan C · Madison, SDBuilt 1958 · S/N CG-209N34CRRounds Donald C DBA · Waller, TXS/N G-758N34DJBrugman Edward J · Hudson, OHS/N CE-483N34DKTennessee Aviation Services LLC · Sevierville, TNBuilt 1962 · S/N G-744N34DTSutton William E · Salinas, CABuilt 1953 · S/N G-114N34DYMccormick Daniel · Salem, SCBuilt 1956 · S/N G-730N34EMSpirit Rotorcraft LLC · Phoenix, AZBuilt 1955 · S/N 53-4150N34EPSkogen James C · Blue Earth, MNS/N G-74N34EVSilva Alexander J · Holly Springs, NCS/N G-16N34FHJeffcoat Jon T · Nome, TXBuilt 1981 · S/N E-1836N34FUWatson George E · Temecula, CABuilt 1956 · S/N BG-180N34GCPhillips Stuart G · Woodside, CABuilt 1982 · S/N EA-283N34JPDakota Aircraft Inc · Pierre, SDBuilt 1973 · S/N CJ-39N34KJWright Wing Aviation LLC · Pittsboro, NCBuilt 1961 · S/N G-715N34KMBravo Adventures LLC · Scottsdale, AZBuilt 1981 · S/N EA-207N34KRH & H Air Inc · Washington, INBuilt 1956 · S/N G-766N34MKBadger Industries LLC · Harvard, ILBuilt 1953 · S/N G-88N34MLDelta Ent Leasing Llp · Brighton, COS/N G-719N34MRN34mr LLC · Orlando, FLBuilt 1952 · S/N G-39N34MTPerigee Investments LLC · Anacortes, WAS/N BG-417N34MXEwald Robert H · Red Lodge, MTBuilt 1984 · S/N PG-114N34PACosentino William D · Lees Summit, MOBuilt 1955 · S/N G-268N34SYGeneral Aviation Modifications Inc · Ada, OKBuilt 1956 · S/N BG-246N34SZWhitt Ronald D · Slinger, WIBuilt 1953 · S/N 53-4120N34TTaylor Kennedy · Courtland, MSS/N D-3712N34TXMccormack Robert · Reno, NVS/N G-796N34UAInternational Air Services Inc Trustee · Carson City, NVS/N D-7241N34VBBarrett Victor L · Sevierville, TNS/N BG-361N34VMRoberts Glenn T · Port Orange, FLBuilt 1954 · S/N G-98N34VWGalloway Chris · Jordan Valley, ORS/N G-80N34VYTrident Aircraft Inc · Easton, MDBuilt 1955 · S/N BG-41N34XAVectored Solutions Inc · Everett, WABuilt 1945 · S/N G-799N34XXBallance Harry Greene Jr · Atlanta, GAS/N BG-54N3500BWalter Charles T Jr · Ocala, FLBuilt 1953 · S/N A-973N3502BKnight Clifton T · Kemah, TXBuilt 1954 · S/N D-3719
Back to AD 99-05-13 R1 WD