OpenAirDocs.org
AD 99-26-19 R1

Registered aircraft · 69

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-26-19-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:99-26-19-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.

N1234CErickson Mark D · Valley Springs, SDBuilt 1937 · S/N 1697N13RNMurphy Dale · Pagosa Springs, COBuilt 1936 · S/N 938N14419Pietsch Warren A · Minot, NDBuilt 1937 · S/N 1607N15965Maxson Lee V · Mesa, AZBuilt 1936 · S/N 509N15971Sanford Mark · Ithaca, NYS/N 515N16314Eaa Chapter 626 · El Dorado, ARBuilt 1936 · S/N 547N16360Dean James J · Sanford, NCBuilt 1943 · S/N 589N16621Stewart Robert J Jr · Erie, PABuilt 1936 · S/N 636N16651Horst Aviation LLC · New Holland, PABuilt 1936 · S/N 666N16667Stewart Mark W · Arnold, MDBuilt 1936 · S/N 682N16743Western Antique Aeroplane & Automobile Museum · Hood River, ORS/N 580N16745Machamer John K · Gettysburg, PABuilt 1936 · S/N 747N16747Curtis Air · Pittsfield, MEBuilt 1936 · S/N 749N16769Castle Air LLC · Livermore, CABuilt 1936 · S/N 771N16935Bowe Drew J · Poplar Grove, ILBuilt 1936 · S/N 801N16947Tre Aviation Corp · Wilmington, DEBuilt 1936 · S/N 813N16957Hurlburt Ronald V DBA · Durand, WIBuilt 1936 · S/N 823N16971Registration Pending · Ashley, MIRegistration pendingBuilt 1936 · S/N 837N16997Womack Cameron M · Jackson, LAS/N 863N17216Morgan Dale C · Mc Calla, ALS/N 882N17220Mcneill Daniel A · Placerville, CABuilt 1936 · S/N 886N17234Berney John E · Morgan Hill, CABuilt 1936 · S/N 1014N17240Brandt Terry R · Hood River, ORS/N 906N17247Antique Preservation Assn Greenfield · Greenfield, IABuilt 1937 · S/N 913N17253Command Aire LLC · Sitka, AKBuilt 1936 · S/N 919N17261Schaller Lee W · New Athens, ILBuilt 1936 · S/N 927N17283Harter Michael R · Greenfield, INBuilt 1937 · S/N 950N17284Ficklin Robert L · Fairbury, ILBuilt 1936 · S/N 951N17287Tomasz Steve · Westland, MIBuilt 1937 · S/N 1222N17525Schulz Michael L · Norfolk, NEBuilt 1936 · S/N 945N17540Sweeney Lori · Murray, KYBuilt 1936 · S/N 1040N17542Griffin Lauriane Trustee · Red Bluff, CABuilt 1936 · S/N 1042N17549Brown Thomas E · Coalinga, CABuilt 1936 · S/N 1049N17554Martinez Anthony Nmn · Great Bend, KSS/N 1057N17569Barry Kevan · Gig Harbor, WAS/N 1069N17579Bell Lawrence · Caldwell, IDBuilt 1936 · S/N 1079N17834Rhinebeck Aerodrome Museum · Rhinebeck, NYS/N 1269N17837Short David J · Warrensburg, MOS/N 1272N17847Flying M Services Inc · Germansville, PAS/N 1282N17854Plourde Steve J · Woodstock, ILS/N 1289N17872Ficklin Robert L · Fairbury, ILBuilt 1937 · S/N 1306N17876Beicker Dennie L · Hernando, MSS/N 1310N17910Old Aeroplane Co LLC · Fort Ogden, FLBuilt 1937 · S/N 1510N19202Jacobs James A · Lakeview, MIBuilt 1937 · S/N 1602N19213Port Townsend Aero Museum · Port Townsend, WABuilt 1947 · S/N 1613N19232Decklar Mark R · Grass Valley, CAS/N 1632N19236Hendrickson Steve L · Lake Stevens, WABuilt 1937 · S/N 1636N19252Kretsinger Steven H Trustee · Eugene, ORBuilt 1937 · S/N 1652N19263Sweeney Aron T · Murray, KYBuilt 1937 · S/N 1663N19285Wright Thomas L · Clyde, OHBuilt 1937 · S/N 1685
Back to AD 99-26-19 R1