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.

N99031Diamond X LLC · Elko, NVBuilt 1954 · S/N 18-3990N99042Spusta James J · Fairview, PABuilt 1955 · S/N 18-3983N9908DJb Aviation · Red Bluff, CABuilt 1959 · S/N 18-6949N9909DDkl Inc · Ardmore, OKS/N 18-6950N9910DMoe Gregor A · Sarasota, FLFirst renewal noticeBuilt 1959 · S/N 18-6951N9911DSullivan Daniel J · Medina, MNS/N 18-6952N9916DUeeck Brett · Anchorage, AKBuilt 1959 · S/N 18-6958N9918DSnow Peter T Jr · Mcgrath, AKBuilt 1959 · S/N 18-6960N9921DRegistration Pending · Missoula, MTRegistration pendingBuilt 1959 · S/N 18-6963N9924DFoshee Todd · Brownfield, TXBuilt 1959 · S/N 18-6967N9925DZaczkowski Paul S · Tok, AKBuilt 1959 · S/N 18-6969N9929PFloeck Lesa M · Tucumcari, NMBuilt 1976 · S/N 18-7709009N992CCAerial Sign Co · Melbourne, FLS/N 5-992N992RMPalm Aerobatic Aircraft LLC · Port Saint Lucie, FLS/N 22-6863N9934DLetkeman John K · Seminole, TXBuilt 1959 · S/N 18-6987N9935DDavis Nigel L · Helena, MTBuilt 1959 · S/N 18-6988N9937DSky High Adventures LLC · Wilmington, DES/N 18-6991N9938DStrub Henry J Jr · Dillingham, AKBuilt 1959 · S/N 18-6993N9939PJensen Carter E · Flaxville, MTS/N 18-7709010N993CCSale Reported · Kasota, MNSale reported, pending cancellationBuilt 2000 · S/N 9910CCN993DBBauer Dereck R · Springfield, ORS/N 22-6904N9941DPye Jenny · Roanoke, TXBuilt 1959 · S/N 18-6997N9944DRed Baron LLC · Dickinson, NDS/N 18-7013N9945PBonner Richard A · Garrettsville, OHBuilt 1976 · S/N 18-7709011N9947DHanshew Steve B · Leesburg, OHBuilt 1959 · S/N 18-7003N9947QQuarberg Donald M · Delta Junction, AKBuilt 1954 · S/N 18-3552N9948QPemberton Addison J · Spokane, WABuilt 1954 · S/N 18-3557N994AQuality Aviation Inc · Marana, AZS/N 22-310N994CCStraight And Level Productions Inc · Bentonville, ARBuilt 2000 · S/N 9911CCN9950DSierra Charlie Aviation LLC · Sandpoint, IDS/N 22-6738N9950QTymitz Peter A · Eagle River, AKBuilt 1955 · S/N 18-3563N9951DDicenzo Eugene N · Cumberland, RIBuilt 1959 · S/N 22-6739N9952DLynch John E · Bourbonnais, ILBuilt 1959 · S/N 22-6740N9952QDutch Air LLC · Kalispell, MTBuilt 1954 · S/N 18-3579N9953DNiner Niner Five Three Delta LLC · Marshall, WIS/N 22-6742N9954DJoy Derek T · Bad Axe, MIBuilt 1959 · S/N 22-6743N9954QSalibo A C · Friendswood, TXS/N 18-3916N9955QWerba Travis J · Anchorage, AKBuilt 1955 · S/N 18-3918N9957DLinett Michael J · Elsmere, DEBuilt 1959 · S/N 22-6746N9957QHarmon Michael D · Mansfield, SDBuilt 1954 · S/N 54-2535N9958DMoore William H · Johnstown, COBuilt 1959 · S/N 22-6748N9959DJohnson Steven Donald · Pardeeville, WIBuilt 1959 · S/N 22-6749N995CCN995cc LLC · Fredericksburg, TXBuilt 2000 · S/N 9913CCN995WN995w LLC · Salem, ORBuilt 1958 · S/N 18-6676N9962QErvin Scott A · Tumwater, WABuilt 1955 · S/N 18-3949N9963DBurlak David M · Waverly, VABuilt 1959 · S/N 22-6754N9963QAnderson Darrin J · Palmer, AKS/N 18-3950N9964QVer Schneider Nicholas R · Forestport, NYS/N 18-3956N9965QDms Leasing Co LLC · Las Vegas, NVBuilt 1955 · S/N 18-3957N9966DZiemann Shaun · Jasper, INBuilt 1959 · S/N 22-6757
Back to AD 99-01-05 R1