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.

N4898MWarren Spencer T · Fritz Creek, AKS/N 11-419N4898YSimmons Mark Adba · Pawcatuck, CTBuilt 1968 · S/N 25-4705N4899AHanneman Delmar R · Lincoln, KSRevoked, canceledS/N 18-5002N489ALHehl Adam D · Anchorage, AKBuilt 1956 · S/N 18-4769N48HAFiack Daniel P · Sun Valley, IDBuilt 1953 · S/N 22-975N48MRCasey Mike P · Whitefish, MTBuilt 1947 · S/N 12-2583N48SJJohnston Stephen P · Hawley, MNBuilt 1948 · S/N 1466N4900CRider Bradley H · Juneau, AKBuilt 2013 · S/N AI-18062N4900MSchwend Brian · Forsyth, MTBuilt 1947 · S/N 11-421N4900ZPeden Max S · Eagleville, TNBuilt 1961 · S/N 22-8483N4901HSchwend Brian · Forsyth, MTBuilt 1948 · S/N 11-772N4901MSchaller Lee · New Athens, ILBuilt 1947 · S/N 11-422N4901ZUnger Michael D · Bellingham, WAS/N 22-8486N4905MHill Andrew J Trustee · Benton, MOBuilt 1947 · S/N 11-427N4906MUnivair Aircraft Corp · Aurora, COBuilt 1948 · S/N 15-2N4907ZChristie Ian A H · Limon, COS/N 22-8492N4908PJohnson Dalton S · Sterling, AKBuilt 1962 · S/N 18-7789N4909MAnte George S · Eagle River, AKBuilt 1947 · S/N 11-1635N4909ZVersatile Aviation LLC · Waterford, MIBuilt 1961 · S/N 22-8494N4910HScott Lonnie L · Nikiski, AKS/N 11-779N4910PWilkens Jacob James · Eagle River, AKBuilt 1962 · S/N 18-7832N4911HBryn Jamie P · Dazey, NDBuilt 1948 · S/N 11-782N4911ZSamson Robert L · Phoenix, AZBuilt 1961 · S/N 22-8496N4913HCascavilla Philip J · Dallas, TXBuilt 1948 · S/N 11-851N4913ZRegistered aircraftS/N 22-8499N4915ZPamment Melvin M · Arlington, KYBuilt 1961 · S/N 22-8501N4916HConnell James L · Bushnell, FLBuilt 1948 · S/N 11-783N4917ZGibsons Gas Inc · Holland, NYS/N 22-8506N4920HHaak Michael Dane · Portland, ORBuilt 1948 · S/N 11-787N4923HNormandeau Daniel R · Thompson Falls, MTS/N 11-790N4923MAircraft Investment Co Inc · Casselton, NDS/N 11-1626N4923YDenton Aerial Spraying Inc · Las Animas, COBuilt 1968 · S/N 25-4620N4923ZWeigel Martin C · Valley City, OHBuilt 1961 · S/N 22-8511N4924MEdwards Wesley E · Hettinger, NDBuilt 1947 · S/N 11-1627N4924ZGlover Thomas B · Marana, AZBuilt 1961 · S/N 22-8514N4925ZKopacz Thomas H · Glen Flora, WIS/N 22-8515N4926HBerry Kevin G · Oakville, WABuilt 1948 · S/N 11-793N4926MBevis Thomas L · Sebring, FLBuilt 1947 · S/N 11-1638N4926YDenton Aerial Spraying Inc · Las Animas, COBuilt 1968 · S/N 25-4724N4927CRegistration Pending · Helena, MTRegistration pending, pending cancellationBuilt 1953 · S/N 18-2116N4927HOlhughes LLC · Staplehurst, NEBuilt 1948 · S/N 11-797N4928HAaberg Ronald N · Pedro Bay, AKBuilt 1948 · S/N 11-805N4928YSpragues Aerial Spraying Inc · Courtenay, NDBuilt 1968 · S/N 25-4727N4929ZDennis Robert · Rosamond, CAS/N 22-8519N4930HSantillan Hannah M · Belgrade, MTBuilt 1948 · S/N 11-802N4930MCinquanta Daril · Arvada, COBuilt 1947 · S/N 111630N4931ZThurmond Kenneth · Eastover, NCS/N 22-8521N4932ZWilczynski John J · Lake Village, INBuilt 1961 · S/N 22-8524N4933MPilster Larry · Alzada, MTBuilt 1947 · S/N 11-1563N4933ZSale Reported · Clio, MISale reportedS/N 22-8525
Back to AD 99-01-05 R1