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.

N8597DRwr Air Inc · Tol, AKBuilt 1957 · S/N 18-6248N8597LCb Aerial Application LLC · Kirksville, MOS/N 25-5022N8598CFrenzel Robert P · Midlothian, TXBuilt 1953 · S/N 22-1271N8598DBurkhart Verlus L · Fairmont, MNBuilt 1957 · S/N 22-5795N85DCCaesar David R · Justin, TXBuilt 1954 · S/N 18-3909N85DFJ3 Shenanigans LLC · Warrensburg, MOBuilt 1939 · S/N 2931N85MNMack Air LLC · Anchorage, AKS/N 18-717N8600CFowler Leo W · Port Alsworth, AKBuilt 1953 · S/N 22-1287N8600DPockrus Pat B · Mineral Wells, TXBuilt 1957 · S/N 22-5796N8601DRubbert Randy C · Reynolds, NDBuilt 1957 · S/N 22-5798N8602CShrode Rafe C · Jewett, TXBuilt 1953 · S/N 22-1282N8602DFithian Cody D · Wasilla, AKBuilt 1957 · S/N 22-5800N8605CColier Neal · Mc David, FLFirst renewal noticeBuilt 1953 · S/N 22-1288N8605DTroxel Robert G · Parma, IDBuilt 1957 · S/N 22-5803N8605LMiller Andy D · Marana, AZS/N 25-5031N8607COllmann Paul W · Poplar Grove, ILS/N 22-1292N8607DDowns Benjamin S · Madison, SDBuilt 1957 · S/N 22-5805N8608DYoung Mike · Albany, CABuilt 1957 · S/N 22-5806N8610CRuss Robert P · Van, TXBuilt 1953 · S/N 22-1293N8612DPerry Leonard M · Soldotna, AKBuilt 1957 · S/N 22-5812N8613DPerry Kenneth V · Katy, TXS/N 22-5811N8614CErdmann Adam C · Raseau, MNBuilt 1953 · S/N 22-1295N8616DFrancis Harvey B · Key West, FLS/N 22-5815N8617DGrisham Michael H · Paulden, AZBuilt 1957 · S/N 22-5820N8618LLatimer Lawrence A · Vernon, TXBuilt 1969 · S/N 25-5047N8619DBenton Mark H · Sussex, WIBuilt 1957 · S/N 22-5822N8619LAerial Banners Inc · Pembroke Pines, FLBuilt 1969 · S/N 25-5049N861APKlein Edwin Andrew Bell · Grass Valley, CABuilt 1957 · S/N 22-4769N8620DMid Atlantic Air Museum · Reading, PAS/N 22-5823N8621DBrown Lonnie S · Lone Jack, MOBuilt 1957 · S/N 22-5824N8622DGrass Strip Life LLC · Gulf Breeze, FLBuilt 1957 · S/N 22-5825N8624CPanter Edwin M · Anchorage, AKBuilt 1953 · S/N 22-1304N8625DMyers Martin John Trustee · Juneau, AKBuilt 1958 · S/N 22-5828N8627LSouthern Cub & Aircraft Restoration LLC · Pensacola, FLBuilt 1969 · S/N 25-5060N8629CSmith Kevin B · Kempner, TXBuilt 1953 · S/N 20-1007N8629DLogan Todd S · Bucyrus, OHBuilt 1957 · S/N 22-5832N8629LKnutson Wayne R · Thompson, NDBuilt 1969 · S/N 25-5063N8631CBrandt Jason A · Boyd, TXS/N 22-1321N8631DMilford Terry R · Mcminnville, TNBuilt 1957 · S/N 22-5834N8632CWalker Michael L · Fredericksburg, TXBuilt 1953 · S/N 22-1324N8632DFranklin Jay D · Cashmere, WABuilt 1957 · S/N 22-5835N8636CJoyce Patrick J · El Cajon, CABuilt 1953 · S/N 22-1315N8636DRui C LLC · Reddick, FLBuilt 1957 · S/N 22-5844N8637CLamphere John M · Middle Island, NYBuilt 1953 · S/N 22-1310N8638LTulsa Skyhawks Inc · Tulsa, OKBuilt 1969 · S/N 25-5076N8639CGeorge James A · Jackson, GAS/N 22-1313N8640CGiddens Robert F · Duncan, OKBuilt 1953 · S/N 22-1316N8642LTexas Soaring Assn · Midlothian, TXBuilt 1969 · S/N 25-5079N8643DBurns Roni R · Bolivar, MOBuilt 1958 · S/N 22-5851N8646CFilice Gennero J · Rohnert Park, CABuilt 1953 · S/N 22-1323
Back to AD 99-01-05 R1