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.

N906CCColumbus Paul S · Laguna Beach, CABuilt 2001 · S/N 9924CCN9071DSturgis Richard G · Wasilla, AKS/N 18-6437N9073DJohnson Joseph S · Eagle River, AKBuilt 1958 · S/N 18-6439N90769Registration Pending · Sterling, AKRegistration pending, pending cancellationBuilt 1963 · S/N 18-7910N9077DLitzen Guide Service Inc · Kenai, AKBuilt 1958 · S/N 18-6443N9078DChandelle Ltd · Brighton, COBuilt 1958 · S/N 18-6446N9078YParker Ron L · Melissa, TXBuilt 1970 · S/N 18-8908N9079DThomas William C · Blanchardville, WIBuilt 1958 · S/N 18-6447N907AGAntique Aircraft And Automobile LLC · Van Alstyne, TXS/N 22-7218N907BPBryant Stephen C · Anchorage, AKS/N 22-2431N907CCOconnor Lloyd Thomas · Dillingham, AKS/N 9907CCN907EEmbley Tommy Jene · Anchorage, AKS/N 12-3921N907FVGuthrie Richard A · Anchorage, AKBuilt 1955 · S/N 18-4387N907JConaway Jeffrey Scott · Anchorage, AKBuilt 1965 · S/N 18-8259N907LCCrowe Talmadge L Jr · Anchorage, AKS/N 18-1111N907RUBlahut Michael · Anchorage, AKBuilt 1950 · S/N 18-192N907SCCrowe Talmadge Layne Jr · Anchorage, AKS/N 18-4584N907STState Of Alaska Department Of Public Safety · Anchorage, AKBuilt 1960 · S/N 18-7262N907UTClaus Paul E · Chitina, AKBuilt 1957 · S/N 18-5547N907WMSpano Darren M · Deville, LABuilt 1979 · S/N 18-8009038N907XLLunenschloss Michael L · Anchor Point, AKBuilt 1976 · S/N 18-7609010N907YTurner Redford J IV · Ninilchik, AKS/N 186291N9080DTrieber Steven M · Eastport, MEBuilt 1958 · S/N 18-6448N9082DLeahy Garry E · Van Wert, IABuilt 1958 · S/N 18-6450N9086DDarrow John K · Soldotna, AKBuilt 1958 · S/N 18-6460N90907Hansen William Robert · Lincoln, MTS/N 18-8109042N90908Charles Wilford W · Big Lake, AKBuilt 1981 · S/N 18-8109043N9091DCanton Logan J · Petersburg, AKS/N 18-6469N90922Blair Ernest J · St Thomas, NDBuilt 1981 · S/N 18-8109045N9092DWilliams Wendell B · Anchorage, AKBuilt 1958 · S/N 18-6470N90931Davies Donald K · Hastings, MNBuilt 1981 · S/N 18-8109048N90943Center Of Gravity LLC · Elmira, NYBuilt 1981 · S/N 18-8109049N90945Pennison Scott J · Nikiski, AKS/N 18-8109050N90947Macleod Andrew S Trustee · Anchorage, AKBuilt 1981 · S/N 18-8109052N90948Ccf Ventures Inc · Bangor, MEBuilt 1981 · S/N 18-8109053N90957Cubcrawlers LLC · Cocoa, FLBuilt 1981 · S/N 18-8109041N9095DBig Dog Aviation LLC · Anchorage, AKBuilt 1958 · S/N 18-6475N9096DHenderson Richard J · Fairbanks, AKBuilt 1958 · S/N 18-6476N90970Darr Realty LLC · Cozad, NEBuilt 1981 · S/N 18-8109054N9097DEllingson Leslie B · Harwood, NDS/N 18-6477N9098DConley Brett M · Salcha, AKBuilt 1958 · S/N 18-6478N90995Peregrine Air LLC · Colorado Springs, COS/N 18-8109057N909ARogers Neil F · New Braunfels, TXBuilt 1951 · S/N 22-213N909APHorton Jeffrey T · Winter Haven, FLBuilt 1994 · S/N 501RAN909TClaus Donna E · Chitina, AKBuilt 1965 · S/N 18-8305N90LSNielsen Eric R Trustee · Anthem, AZBuilt 1978 · S/N 18-7909025N91005Clayton Connley N · El Nido, CABuilt 1981 · S/N 18-8109060N91019Garcia Roberto P · Spring Hill, FLS/N 18-8109063N9101YSafeflite Aviation LLC · Glenwood, IAS/N 5-710N91024Blue Water Consulting LLC · Dorchester, SCBuilt 1981 · S/N 18-8109065
Back to AD 99-01-05 R1