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.

N3284BGlover Gary J · Columbia, SCBuilt 1954 · S/N 22-2104N32857Henley Charles D · New London, NCBuilt 1940 · S/N 5665N32879Geisler Mark C · Dallas, TXBuilt 1940 · S/N 4-1314N3287MMillar George B · Le Claire, IABuilt 1947 · S/N 12-2038N3287ZIsburgh Andrew N · Conyers, GABuilt 1959 · S/N 18-7210N32880Cook Mike R · Rye, COBuilt 1940 · S/N 4-1318N32884Schildberg Gregory M · Casey, IABuilt 1940 · S/N 4-1324N32887Groskurth Walter I · Mankato, MNBuilt 1940 · S/N 5-393N3288ZOney John M · Anchorage, AKBuilt 1959 · S/N 18-7218N32892R&L Air Service LLC · Yatesville, GABuilt 1940 · S/N 5399N32899Carter James W · Pflugerville, TXBuilt 1949 · S/N 5408N3289MWilliams Kiplin S · Midland, NCBuilt 1947 · S/N 12-2141N32908Losey Charles N · Winfield, TNBuilt 1940 · S/N 5692N3290MMullins Esten R · El Paso, TXBuilt 1947 · S/N 12-2151N3290ZDykema Richard · Kenai, AKS/N 18-7227N32918Comanche Warbirds Inc · Houston, TXBuilt 1949 · S/N 5709N32920James Peter L · Fennimore, WIS/N 5702N3292ZAlbertson James M · Westville, FLBuilt 1959 · S/N 18-7229N3293BHuttunen Alice D Trustee · Wasilla, AKBuilt 1954 · S/N 18-3287N3293ZStraight And Leve Aeromedical LLC · Billings, MTS/N 18-7230N32942Bent James L Jr DBA · Palatine Bridge, NYS/N 18-7231N32946Williams Robert M · Red Hook, NYBuilt 1940 · S/N 5730N3294BSylvester Robin R · Soldotna, AKBuilt 1954 · S/N 18-3292N3294MLorenzo Jennifer A · Meridian, IDBuilt 1947 · S/N 12-2142N32955Finn Kathryn L K · Grand Marais, MNS/N 5739N3295MParamount Air Service · Rio Grande, NJBuilt 1947 · S/N 12-2143N32966Tumbleson Shelly L · San Antonio, TXBuilt 1940 · S/N 5750N32967Ward Jeffrey A · Waynesboro, VABuilt 1940 · S/N 5751N3297BStevens Lance R · Kennewick, WAS/N 18-3299N3297MHyrkas Thomas K · Calumet, MIS/N 12-2153N3297ZFarm Air Flying Service LLC · Sacramento, CAS/N 18-7238N32985Woodward Christopher L · Manchester, TNBuilt 1940 · S/N 5-410N32986Smith Lane W · White Salmon, WABuilt 1940 · S/N 5-424N32989Wiggins Cory L · Oak Grove, LAS/N 5-412N32996Blythe Joseph L · Rockwall, TXBuilt 1940 · S/N 5-420N3299BWamberg Donald D · North Bend, NEBuilt 1954 · S/N 18-3302N3299MJorgensen Duwayne L · Effort, PAS/N 12-2146N329DPHitchcock Aviation LLC · Twin Falls, IDS/N 18-7609149N329FPNetwork Spares · Wilmington, DEBuilt 1969 · S/N 18-7421N329TKaney Jeffrey J · Naples, FLBuilt 1953 · S/N 18-2443N329TADelta Pacific Northwest LLC · Anchorage, AKBuilt 1968 · S/N 18-8699N32HBBeals Thomas · Spotsylvania, VAS/N 18-7509046N3300BJohnson Rusty E · Enumclaw, WABuilt 1954 · S/N 22-2114N3300ZKoliastasis Pete · Reno, NVBuilt 1959 · S/N 22-7231N3301ASmith Randall P · Fort Worth, TXS/N 22-1583N3301BLux Jason M · King Salmon, AKBuilt 1954 · S/N 22-2116N3301ZWood Paul S · Lawton, OKBuilt 1959 · S/N 22-7232N33027Wilder Russell C · East New Market, MDBuilt 1949 · S/N 5785N33029Taylor William L · Fairview, ORBuilt 1940 · S/N 5-430N3302BNehrkorn Ruediger · Slate Hill, NYBuilt 1954 · S/N 22-2117
Back to AD 99-01-05 R1