OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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-01-05-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-01-05-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.

N3186MKuenzli Casey I · Nyssa, ORS/N 12-2013N3187MZimmerman Kyle R · Gilbert, AZBuilt 1947 · S/N 12-2014N3188MBirch Jerome I Trustee · Anchorage, AKBuilt 1947 · S/N 12-1867N318EAKlabunde Andrew G · Menasha, WIS/N 18-3905N318FMMatonti James Robert · Oklahoma City, OKS/N 18-5993N3190MHart David E · Jackson, GABuilt 1947 · S/N 12-2008N3191MHerder John P · Phoenix, AZBuilt 1947 · S/N 12-2007N3194PGalindo Don R Jr · Walnut Grove, CABuilt 1980 · S/N 18-8009042N3194ZEvans Michael J · Woodstock, ILBuilt 1959 · S/N 18-7190N3195ZMcgrady Chadwick Paxton · Glade Park, COBuilt 1959 · S/N 18-7191N3197ZSlayden Steven M · Rhome, TXBuilt 1959 · S/N 18-7195N3199MDe Voe Don F · Anchorage, AKBuilt 1947 · S/N 12-1862N31BTMiddle Georgia Aviation Inc · Cochran, GABuilt 1960 · S/N 22-7447N31JPOstmeyer John M · Gardner, KSBuilt 1956 · S/N 22-3913N3200BMuehl Harvey C · Macomb, MIBuilt 1954 · S/N 22-2027N3200GSpinner Family Limited Partnership · White City, ORBuilt 1956 · S/N 22-4042N3200MPride Jesse D · Eagle River, AKS/N 12-1872N3200ZBrady Michael E · Buffalo, NYBuilt 1959 · S/N 22-7140N3201ZMcclain William J · Corona, CABuilt 1959 · S/N 22-7141N3203MDavid Dorin A · Kasilof, AKBuilt 1947 · S/N 12-1873N3205BDurben Robert W · Newcomerstown, OHBuilt 1953 · S/N 22-2032N3206BNull Clifford M · Punxsutawney, PAS/N 22-2033N3208BBallou Robert L · Puyallup, WABuilt 1953 · S/N 22-2035N3209BDebuck Nathan J · Edgewood, NMS/N 22-2036N320SHMoore Michael C · Anchorage, AKBuilt 1956 · S/N 185060N3210Perry Daryl C · Sanford, NCBuilt 1961 · S/N 22-8079N3210EGrove Douglas W · Flemington, PABuilt 1947 · S/N 12-1473N3211BHinton Scott · Elizabeth City, NCBuilt 1953 · S/N 22-2038N3211FJohnson Kenneth E · Sterling, AKBuilt 1974 · S/N 11-238N3212PEllis Samuel F Jr · Copperas Cove, TXS/N 6341N3213ZDasher Daryl L · Boring, ORBuilt 1959 · S/N 22-7153N3214DHill James P · Eagle Point, ORS/N 18-8209025N3214SWebb Mike J · North Pole, AKS/N 18-8309004N3215ZCastle Richard E · Callao, MOS/N 22-7155N3217ZQuality Aviation Inc · Marana, AZFirst renewal noticeBuilt 1959 · S/N 22-7158N3218MAthol Aggregate LLC · Athol, IDBuilt 1947 · S/N 12-1881N3219GWest Mi Shooting Alliance For Excellence Sfty LLC · Marne, MIBuilt 1976 · S/N 18-7709030N321TBradshaw & Company Insurors · Dyersburg, TNBuilt 1953 · S/N 18-2435N321VBYoung Mike · Loop, TXBuilt 1960 · S/N 18-7533N3222MRegistered aircraftBuilt 1947 · S/N 12-1887N3222ZBoggs Anthony M · Pringle, SDBuilt 1959 · S/N 22-7163N32230Chadwick Parker · Townsend, MTBuilt 1952 · S/N 18-88N3224BSkyward Solutions Inc · Lewes, DEBuilt 1954 · S/N 22-2052N3224MGazarian Kevin A · Kingsburg, CABuilt 1947 · S/N 12-2023N3224ZBagley Sherell G · Suwanee, GABuilt 1959 · S/N 22-7168N3225BLeguia Augusto A · Kathleen, GABuilt 1954 · S/N 22-2053N3226MHurlburt William J · Avoca, NYBuilt 1947 · S/N 12-2105N3227MParker Shon T · Wasilla, AKBuilt 1947 · S/N 12-2108N3228BScites Robert · Toney, ALS/N 22-2057N3229MKrogh Arne A · Anchorage, AKBuilt 1947 · S/N 12-2107
Back to AD 99-01-05 R1