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.

N2961PRegistered aircraftBuilt 1955 · S/N 22-3234N2963MSouthmost Aviation Inc · Brownsville, TXBuilt 1946 · S/N 12-1357N2964MMcgee David · West Monroe, LABuilt 1946 · S/N 12-1358N2966CJames Neil · Scott City, KSS/N 5-804N2966ZKieffer William · Chillicothe, MOS/N 22-6940N2967ZChance Carl R · Victoria, TXS/N 22-6941N2968PRankin Kevin · Maryville, MOBuilt 1955 · S/N 22-3242N2968ZKuebler Terry T · Gahanna, OHFirst renewal noticeBuilt 1959 · S/N 22-6943N2969MAerial Banners North Inc · Pembroke Pines, FLBuilt 1946 · S/N 12-1456N296BCKrein Christopher L · Bismarck, NDS/N 18-7877N296JPJpm Flying Service LLC · Marine, ILBuilt 1951 · S/N 181185N296TPm Aviation LLC · Missoula, MTBuilt 1953 · S/N 18-2410N2970PWilson Julie · Prineville, ORBuilt 1955 · S/N 22-3244N2971MFoothill Aviation LLC · Iliamna, AKBuilt 1946 · S/N 121363N2971PRinglein Thomas · Mokelumne Hill, CAS/N 22-3246N2971ZTodorov Krasimir · San Diego, CABuilt 1959 · S/N 22-6946N2972MMckinney John C · Susquehanna, PABuilt 1946 · S/N 12-1459N2973MPage Mack F · Parker, COBuilt 1946 · S/N 12-1460N2973PHauser Nathan S · Newark, DES/N 22-3248N2974PMiller Daniel F · Grain Valley, MOBuilt 1955 · S/N 22-3249N2975MMartin Nathaniel W · Wasilla, AKBuilt 1946 · S/N 12-1457N2975ZHesse Paul William · Oxford, NCBuilt 1959 · S/N 22-6949N2977MLindberg Thomas W · Anchorage, AKBuilt 1946 · S/N 12-1364N2978PFrohnapfel Mark · Cordova, AKBuilt 1955 · S/N 18-4516N2979ZHickle William H · Inyokern, CABuilt 1959 · S/N 18-7090N2980ZMckinney Kurt L · Fairbanks, AKBuilt 1959 · S/N 18-7091N2981PGray Ellie · Anchorage, AKBuilt 1955 · S/N 18-4519N2983PEastgate Motors Inc · Salem, ORS/N 18-4521N2983ZFisher Charlton D · Houston, TXBuilt 1959 · S/N 18-7094N2984MFitts Robert D · Independence, ORBuilt 1946 · S/N 12-1369N2986MHarwood Thomas K · Fairbanks, AKBuilt 1946 · S/N 12-1371N2986PBentley Aero Inc · Wilmington, DEBuilt 1955 · S/N 18-4499N2986ZWharton Betty E · Amarillo, TXFirst renewal noticeBuilt 1959 · S/N 18-7100N2987MLonguski Francis J · Vassar, MIBuilt 1946 · S/N 12-1372N2987PSmall Mark B · Walla Walla, WAS/N 18-4500N2988PKadrmas Ryan · Dickinson, NDFirst renewal noticeBuilt 1955 · S/N 18-4501N298SQEastern Stearman Inc Trustee · Leesburg, VABuilt 1952 · S/N 18-1586N298TTruair LLC · Chaska, MNS/N 18-2412N2991MKesling Robert W · Scottville, MIS/N 12-1464N2991PHofer Todd Paul · Doland, SDBuilt 1955 · S/N 18-4504N2992PLowe Danny D · Wasilla, AKBuilt 1955 · S/N 18-4505N2993ZKrupinski Floyd M · Chugiak, AKBuilt 1959 · S/N 18-7112N2994ZAir Ads Inc · El Cajon, CABuilt 1959 · S/N 18-7113N2996MRogers Brandon · Lubbock, TXBuilt 1946 · S/N 12-1467N2996PHenry Kent B · Prescott, AZBuilt 1955 · S/N 18-4510N2997ZHoppner Gina · Fairbanks, AKFirst renewal noticeBuilt 1959 · S/N 18-7122N2998PRosendahl Peter · Anchorage, AKBuilt 1955 · S/N 18-4514N299TAnderson Christopher S · Wasilla, AKS/N 18-2413N29FDRegistered aircraftAssigned, pending cancellationS/N 12-1449N29LGCameron Mark · Alpine, WYFirst renewal noticeS/N 184783
Back to AD 99-01-05 R1