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.

N8105EPockrus Pat · Mineral Wells, TXBuilt 1951 · S/N 22-94N8105YGates Christopher H Jr · Chugiak, AKBuilt 1958 · S/N 18-6387N8106YLake Country Lodge Inc · Port Alsworth, AKBuilt 1966 · S/N 18-8588N8107YBrownfield Ranch Inc · Hammond, MTBuilt 1970 · S/N 18-8856N8108DKanz Peter J · Wasilla, AKS/N 22-5599N8109YStoor Danny · Fountain Hills, AZS/N 18-8591N8112PButler Tracey D · Buckley, WABuilt 1955 · S/N 222567N8113CCzech Nathanial · Airway Heights, WAS/N 22-2259N8113DHedditch David R · Victor, MTBuilt 1957 · S/N 22-5603N8114DFarago John A · Grapevine, TXS/N 22-5605N8115CKrzywdzinski Douglas E · Beaumont, CAS/N 22-2261N8115DOsborne Richard Tyler · Anderson, SCBuilt 1957 · S/N 22-5606N8118CAnderson Todd · Dayton, OHBuilt 1954 · S/N 22-2264N8119DHam Keith W · Kasilof, AKS/N 22-5610N811AJScarrow Justin · Palmer, AKS/N 18-8457N811DWPerucca Douglas E · Wasilla, AKBuilt 1961 · S/N 18-7582N8122CJordan Walter B · Chehalis, WABuilt 1954 · S/N 22-2268N8122DCarothers Edward L · Jersey Shore, PAS/N 22-5613N8126DHackleman Brian K · Rochester, NYS/N 22-5617N8127DTrimmer Marvin E · Willow, AKBuilt 1957 · S/N 22-5618N8128DBuckner John L · Ragland, ALBuilt 1957 · S/N 22-5619N812STAk8 Assets LLC · Talkeetna, AKBuilt 1958 · S/N 22-6408N8130DEmbree Walter G · Harrisonburg, VAS/N 22-5621N8131DThompson Arthur W · Paris, TXBuilt 1957 · S/N 22-5622N8132CRitel Copter Service Inc · Hudson, IABuilt 1954 · S/N 22-2278N8134CCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 22-2296N8134DDewolf Logan J · Eagle River, AKS/N 22-4778N8135DDickerson Joseph Ra · Anchorage, AKBuilt 1957 · S/N 22-5626N8138DAir Group Inc · Marietta, GABuilt 1958 · S/N 22-5629N8140CMenier Robert · Milltown, WIS/N 22-2285N8140DMckellar John T · Hamburg, NYBuilt 1957 · S/N 22-5631N8141CHoff Fredrick · Twin Falls, IDBuilt 1954 · S/N 22-2286N8141DCasper Glen · Garden City, KSS/N 22-5632N8142DMontague Mark W · Reno, NVBuilt 1957 · S/N 22-5633N8142YGarner Charles E · Sitka, AKBuilt 1967 · S/N 18-8593N8143CNazelrod Eric V · Washington, OKBuilt 1954 · S/N 22-2288N8143ECadet Air Corps Museum · Tarkio, MOS/N 18-2150N8144CMusgrove Stacy J · Cunningham, TXBuilt 1954 · S/N 22-2289N8145COlson Caden · Billings, MTS/N 22-2290N8145DJindra Russell L · Glennallen, AKBuilt 1957 · S/N 22-5636N8146CClark David A · Plainfield, INBuilt 1954 · S/N 22-2291N814JMLake Country Lodge · Port Alsworth, AKBuilt 1967 · S/N 18-8608N8150DBush Pacer LLC · Watauga, TNBuilt 1957 · S/N 22-5641N8151DWoods Brian S · Longview, TXBuilt 1957 · S/N 22-5642N8156DMoyle Matthew L · Soldotna, AKBuilt 1957 · S/N 22-5647N8158DBates James H · Lakeview, ORBuilt 1957 · S/N 22-5649N8163CSikveland Nils · Richey, MTBuilt 1954 · S/N 18-3619N8163DScoggin Jarrod B · Palmer, AKBuilt 1957 · S/N 18-6141N8165DReabe Robert E · Waupun, WIBuilt 1957 · S/N 18-6146N8166DWillis Bernie W · Wasilla, AKBuilt 1957 · S/N 18-6142
Back to AD 99-01-05 R1