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.

N3364MDrozd Dean P · Lake Dallas, TXBuilt 1962 · S/N 12-2239N3365BSmith James A · Lyle, WABuilt 1954 · S/N 22-2170N3368ZWatts Paul D · Weatherford, TXBuilt 1960 · S/N 22-7283N3369ADoster Michael L · Nampa, IDBuilt 1953 · S/N 22-1667N3369MCallen Jerry R Jr · Jerome, IDBuilt 1947 · S/N 12-2218N3370AHospodar Robert P · Georgetown, PAS/N 22-1627N3370MPetrie Charles W III · Pahala, HIBuilt 1947 · S/N 12-2242N3371BEllis William Cole · Gakona, AKFirst renewal noticeBuilt 1954 · S/N 18-3494N3372BRegistration Pending · Fairbanks, AKRegistration pendingBuilt 1954 · S/N 18-3496N3372ZPhilbrick Stephen C · Oquossoc, MEFirst renewal noticeBuilt 1960 · S/N 18-7245N3374ASinosky Kendall Ansley · Anchorage, AKS/N 22-1631N3374BFederico Leonard A · Reno, NVBuilt 1954 · S/N 183502N3374ZKing Paul E · Albany, ORBuilt 1959 · S/N 18-7249N3375ATatalovich George · Rome, OHS/N 22-1628N3375MScott Rudee L · Anchorage, AKBuilt 1947 · S/N 12-2224N3375ZHall James E III · Lumber Bridge, NCBuilt 1960 · S/N 18-7250N3377ABuller Wilbur D · Redding, CABuilt 1953 · S/N 22-1632N3377ZMorris David S · North Pole, AKBuilt 1960 · S/N 18-7258N3378AThompson William A · Wenatchee, WAS/N 22-1635N3379AKurronen Eric D · Anchorage, AKBuilt 1953 · S/N 22-1634N337ABPlane And Simple Leasing LLC · Delano, MNBuilt 1960 · S/N 25-459N337EFFord Esel W Jr · Mustang, OKS/N 18-3337N337RMErfle Gordon A · Rapelje, MTS/N 5-338N337TJeanes Douglas G · Frisco, TXBuilt 1953 · S/N 18-2451N3380AStephan Pamela K · Anchorage, AKS/N 22-1637N3380MSkaggs Jay D · Eagle River, AKBuilt 1947 · S/N 12-2227N3380ZSchwend Brian · Forsyth, MTBuilt 1960 · S/N 18-7261N3381MAdirondack Legacy Aircraft LLC · Saratoga Springs, NYBuilt 1947 · S/N 12-2230N3382MGarber Linn A · Custer, SDBuilt 1947 · S/N 12-2229N3383ABishop John Patrick · Annapolis, MDBuilt 1953 · S/N 22-1646N3383BEvans Johnny D II · Billings, MTBuilt 1954 · S/N 22-2182N3383ZMcghee Johnny A · Louisburg, NCBuilt 1960 · S/N 18-7267N3384ZJones Robert D Jr · Chugiak, AKBuilt 1960 · S/N 18-7268N3385BSlipshod Aviation LLC · Hurricane, UTBuilt 1954 · S/N 22-2184N3385MBenninger Timothy A · Cobleskill, NYBuilt 1952 · S/N 12-2058N3386MCoffey Daniel J · Hartford, WIS/N 12-2057N3387ZBlake Clark D · Belle Fourche, SDBuilt 1960 · S/N 18-7271N3388BMccracken Scott O · Maysville, OKBuilt 1954 · S/N 22-2187N3388MPatton Derek L · Fort Wainwright, AKBuilt 1947 · S/N 12-2056N3388ZPuckett Keith A · Syracuse, KSBuilt 1960 · S/N 18-7272N3389ZTorgerson'S LLC · Ethridge, MTBuilt 1960 · S/N 18-7274N338PPeters Duane A · Anchorage, AKS/N 11837N338TSiegford Riley E · Anchorage, AKBuilt 1953 · S/N 18-2452N3390AEngen John E · Soldotna, AKBuilt 1954 · S/N 22-1661N3391AMummey Gary E · Stockport, OHBuilt 1953 · S/N 22-1650N3391ZThompson Michael M · Soldotna, AKBuilt 1960 · S/N 18-7276N3392AEverts Air Service Inc · Sarasota, FLS/N 22-1652N3392MOwens Gary R · Talkeetna, AKBuilt 1947 · S/N 12-2236N3392NStraight Gary D · Wasilla, AKBuilt 1946 · S/N 22594N3393HHigh Exposure Inc · Wilmington, DES/N 12-1973
Back to AD 99-01-05 R1