OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,638

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.

N145ABAerial Banners Inc · Pembroke Pines, FLBuilt 1965 · S/N 25-3137N145CSchmitt Mark R · Rockford, MIBuilt 1954 · S/N 18-3335N1460CMaki Tim J · Hibbing, MNBuilt 1953 · S/N 18-2659N1465ALarsen Caesar S · Pleasanton, CABuilt 1951 · S/N 22-372N1466CBent James L Jr DBA · Palatine Bridge, NYS/N 18-2668N1467CWeflen Arvid W · Fairbanks, AKBuilt 1953 · S/N 18-2682N1469AJohnson Steven C · Cheyenne, WYBuilt 1952 · S/N 22-377N146CCRegistered aircraftBuilt 2004 · S/N 9970CCN146MRiddles Michael P · Poulsbo, WABuilt 1946 · S/N 12-703N146THanson Brady W · Soldotna, AKBuilt 1952 · S/N 18-2260N1470CHillestad Darrell L · Aberdeen, SDBuilt 1953 · S/N 18-2670N1471AJames Norris J · Kannapolis, NCBuilt 1952 · S/N 22-378N1471CNorris Cathy J · Statesville, NCS/N 18-2673N1472ASmith Wesley P · Donnelly, IDBuilt 1952 · S/N 22-379N1473CGo Aviation Inc · Potsdam, NYBuilt 1953 · S/N 18-2677N1474ARichard Waldren LLC · Newberg, ORS/N 22-385N1474CSweeney Brett D · Anchorage, AKBuilt 1953 · S/N 18-2678N1476CAsher Debra L · Wasilla, AKBuilt 1953 · S/N 18-2681N1477Rubbert Jan D · Upham, NDS/N 14-77N1478ABehr Casper J · Neavitt, MDBuilt 1952 · S/N 22-392N1479AOlson Phillip Francis · Tenino, WABuilt 1952 · S/N 22-391N147MTMiddle Tennessee State University · Murfreesboro, TNBuilt 1974 · S/N 18-7409136N147PZZattoni Peter D · Mountain Iron, MNBuilt 1947 · S/N 11-1084N147TScrobola James M · Wyoming, PABuilt 1953 · S/N 18-2261N1480CJohnson Mark A · Thousand Oaks, CABuilt 1953 · S/N 22-1203N1481AViseur Michael E · Tulsa, OKBuilt 1952 · S/N 22-389N1482CKnutsen Wayne R · Thompson, NDBuilt 1953 · S/N 22-1205N148CCDream Aero Holdings LLC · Clackamas, ORBuilt 2003 · S/N 9955CCN148TRegistered aircraftBuilt 1953 · S/N 18-2262N1491ASale Reported · Lone Jack, MOSale reportedBuilt 1952 · S/N 20-840N1492AKessler David Keith · Mineral Wells, TXBuilt 1952 · S/N 22-400N1493CH G Klug Sons Inc · Omaha, NEBuilt 1953 · S/N 18-2687N1493HThomas Allen C · Willow, AKS/N 14-93N1494AHelton Tom H · Santa Ana, CABuilt 1952 · S/N 22-398N1495ARamos Benjamin · Yuma, AZS/N 22-402N1497ASlagle Steven D · Auburn, WABuilt 1952 · S/N 22-417N1498ASpivey Larry B · Milledgeville, GABuilt 1952 · S/N 22-403N149AKSmith Megan · Palmer, AKS/N 121338N149CGMoran John R · Port Saint Lucie, FLBuilt 1982 · S/N 18-8209011N149NGerner Carl T · Cadyville, NYBuilt 1947 · S/N 11-1421N14HRRegistered aircraftBuilt 1947 · S/N 12-2853N14LDCopper Mountain Aviation LLC · Port Alsworth, AKBuilt 1955 · S/N 18-4450N14YLHarker James P · Blaine, MNBuilt 1945 · S/N 5-3005N1500JBent James L Jr DBA · Palatine Bridge, NYS/N 18-294N1500PBent James L Jr DBA · Palatine Bridge, NYS/N 18-3672N1501ASchaus Richard M · Schoolcraft, MIBuilt 1951 · S/N 20-685N1502AInternational Air Services Inc Trustee · Carson City, NVBuilt 1951 · S/N 20-686N1502PCarey Daniel F · Long Beach, NYBuilt 1954 · S/N 22-2366N1503PRegistered aircraftBuilt 1954 · S/N 22-2367N1504AHise Kevin E · Rock Rapids, IABuilt 1951 · S/N 20-688
Back to AD 99-01-05 R1