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.

N2736MBrummer Christopher P · Wasilla, AKBuilt 1946 · S/N 12-1137N2736PBeard Jared · Fallon, NVBuilt 1955 · S/N 22-3043N2737MGautreau Peter F · Chickaloon, AKBuilt 1946 · S/N 12-1141N2738MKerner Frank W · Saint Charles, MOBuilt 1946 · S/N 12-1227N273CCRegenald Michaud Aviation LLC · Willows, CABuilt 2001 · S/N 9920CCN273TKing Kalin J · Valdez, AKBuilt 1953 · S/N 18-2387N2740MWroe Daniel C · Denton, MDS/N 12-1230N2743MKemp Dale W · Lampasas, TXBuilt 1946 · S/N 12-1229N2746MStonecipher Wayne H · Yamhill, ORBuilt 1947 · S/N 12-1233N2746PParish Brandon · Mendon, UTBuilt 1955 · S/N 22-3053N2747MGuy Vaughn Zindel III · Eden, UTBuilt 1946 · S/N 12-1234N2747PSvendsen Jon A · Wasilla, AKBuilt 1955 · S/N 22-3054N2748MLathrop Patrick W · Kent, WABuilt 1946 · S/N 12-1235N2748PHess Gary A · Petoskey, MIBuilt 1955 · S/N 22-3055N274JZAcv Group LLC · Mckinleyville, CABuilt 2001 · S/N 9921CCN274WEShenton John J · New Harbor, MEBuilt 1979 · S/N 18-7909120N2750PHill Kevin M II · Dudley, MAS/N 22-3057N2751PSmith Kevin L · Peachtree City, GABuilt 1955 · S/N 22-3058N2752PAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1955 · S/N 22-3059N2753TGarretson Mark W · Victoria, TXS/N 5-1213N2754MWheaton Lee H · Patten, MEBuilt 1946 · S/N 12-1241N2755MKerwin Peter M · Naperville, ILBuilt 1946 · S/N 12-1240N2757MHaring Clay · Lincoln, KSBuilt 1946 · S/N 121238N2758MHaring Clay · Lincoln, KSBuilt 1946 · S/N 12-1154N2759PWilkinson Kevin · Alliance, NES/N 22-3067N275CCSellers Richard V · Byron, CABuilt 2001 · S/N 9922CCN2760PDickerson Gary M · Homer, AKBuilt 1955 · S/N 22-3070N2761PCarlin Thomas J · N Richland Hills, TXBuilt 1955 · S/N 22-3071N2762MRaymond Mark A · East Jordan, MIBuilt 1946 · S/N 12-1158N2764PBrine William R · Pahrump, NVS/N 22-3075N2765MExperimental Aircraft Association Chapter 1218 · Willow Springs, MOBuilt 1946 · S/N 12-1167N2766PMarti Larry B · Rolla, MOS/N 22-3077N276CCWilson Spencer K · Mount Pleasant, SCS/N 9923CCN276TMurray Craig P · Hagaman, NYS/N 18-2390N2770MThissell David W · Plymouth, MABuilt 1946 · S/N 12-1149N2771PWeyrauch Paul H · Ray, NDBuilt 1955 · S/N 18-4399N2772MDexter Fred H · Live Oak, FLBuilt 1946 · S/N 12-1245N2773MWinby Elize Aj · Palo Alto, CABuilt 1946 · S/N 12-1247N2773PZerbe Grant N · Frazer, MTBuilt 1955 · S/N 18-4402N2774PRiver Solutions LLC · Cushing, OKS/N 18-4403N2775PMccann John P III · Greenville, PABuilt 1955 · S/N 18-4406N2778MMiller Benny · Canutillo, TXBuilt 1946 · S/N 12-1159N2779PLaabs Donald L · Anchorage, AKBuilt 1955 · S/N 18-4413N27807Goebel James W · Loveland, OHBuilt 1940 · S/N 4-1023N2780MHerrington James W · Locust Grove, GAFirst renewal noticeBuilt 1946 · S/N 12-1168N27834Smith Ronald M · Brawley, CABuilt 1940 · S/N 4-1052N27836Zigmont David E · Brodhead, WIBuilt 1940 · S/N 4-1055N27844Montgomery Darrell R · Dayton, OHBuilt 1940 · S/N 4-1064N27849James Edward Adam · Strongsville, OHS/N 4-1069N2784MWarwick Steven D · Middletown, DEBuilt 1946 · S/N 12-1165
Back to AD 99-01-05 R1