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.

N2225MBerry Darrel · Camden, TNBuilt 1946 · S/N 21017N2226ABrandt Benjamin R · Avon, SDBuilt 1952 · S/N 22-624N2227CCain Jeffrey B · Godley, TXBuilt 1954 · S/N 18-4011N222MJHonore Breen Aviation LLC · Allegan, MIS/N 12-1905N222SKArnold Sarah Diane · Benton, TNBuilt 1948 · S/N 17-75N222TMJtm Ranches Equipment LLC · Dallas, TXBuilt 1981 · S/N 18-8109081N2230YRickman Wanda M · Absarokee, MTS/N 18-2310N2239AGoring Hugh W · Rimrock, AZBuilt 1952 · S/N 22-635N2239YSale Reported · Lakeland, FLSale reportedS/N 5536N223CGBeckett Jesse · Lakeway, TXBuilt 1947 · S/N 12-2480N223TFalconeri Michael A · Ketchikan, AKS/N 18-2337N2243AWilson Edward M · Urbandale, IABuilt 1952 · S/N 22-646N2246ABent James L Jr · Palatine Bridge, NYS/N 20-906N224TVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1953 · S/N 18-2338N224TPSale Reported · Carson City, NVSale reported, pending cancellationBuilt 1955 · S/N 22-2950N2250ASteele Matthew L · Saint Croix Falls, WIBuilt 1952 · S/N 22-652N2254AGarrett William H · West Des Moines, IABuilt 1952 · S/N 20-908N2258AGraham Steven K · Mc Grath, AKBuilt 1952 · S/N 20-909N225ABMinden Soaring Club Inc · Minden, NVBuilt 1967 · S/N 25-4236N2261AFlying Start LLC · Wilmington, DEBuilt 1952 · S/N 18-1887N2262GRegistered aircraftBuilt 1946 · S/N 12-1183N2265AAsher Kevin C · Wasilla, AKBuilt 1952 · S/N 18-1888N226JKSmith David C · Brewster, WABuilt 2004 · S/N 9965CCN226TMcallister Hunter · Medford, ORBuilt 1953 · S/N 18-2340N22703Daphna Inc · Middletown, DEBuilt 1938 · S/N 4-420N22707Seppala Matthew T · Hortonville, WIBuilt 1938 · S/N 2680N22714Johnson Curtis · Somers, NYBuilt 1938 · S/N 2688N22724Moran Peter James · Como, MSBuilt 1938 · S/N 4-431N22725Gebhart Daniel T · Hanover, PABuilt 1938 · S/N 4426N2272ARegistered aircraftBuilt 1952 · S/N 20-911N2272ZMohar Fred B Jr · Turner, MTBuilt 1954 · S/N 18-3549N22764Rice Allen P · Caldwell, IDS/N 4-451N22772Wilcox J K · Lakeland, TNBuilt 1939 · S/N 4-456N22778Binns Jeffrey E · Hackettstown, NJBuilt 1939 · S/N 4-459N22787Bosworth Michael A · Sabetha, KSBuilt 1938 · S/N 2722N2278AStafford David C · San Luis Obispo, CABuilt 1952 · S/N 22-665N2279AScott Michael Sr · Kahoka, MOFirst renewal noticeBuilt 1952 · S/N 22-668N227JBMorehouse Flying Service Inc · Mer Rouge, LABuilt 1977 · S/N 18-7709114N227TYoung Donald O · Easley, SCBuilt 1953 · S/N 18-2341N2282AGonsioroski Charles F · Baker, MTS/N 22-674N22854Ferguson Jean C · Forest, VABuilt 1939 · S/N 4497N2287YJetran LLC · Horseshoe Bay, TXS/N 18-2434N22881Piper Aviation Museum Foundation · Lock Haven, PABuilt 1939 · S/N 4-502N22884Meinen Albert D · Troy, ILBuilt 1939 · S/N 2794N22894Elnitski Jeffrey J · Bellefonte, PAS/N 2802N2289ABauer Melchior E · Vallejo, CAS/N 22-677N228TWb Aviation LLC · Saint Jo, TXBuilt 1953 · S/N 18-2342N22918Treadway Timothy G · Burton, TXBuilt 1939 · S/N 2815N22934Sonex Aircraft LLC · Oshkosh, WIBuilt 1939 · S/N 2834N2294AWeber Jacob · Homer, AKBuilt 1952 · S/N 22-679
Back to AD 99-01-05 R1