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.

N41110Davis Chris D · Athens, GAS/N 7756N41112Storlie Chris A · Decorah, IABuilt 1941 · S/N 7758N4111HWhalen Mark P · Millington, MDBuilt 1947 · S/N 12-3547N4111ZBredin Thomas W · Anchorage, AKBuilt 1964 · S/N 18-8153N41121Pa-18 LLC · Hood River, ORS/N 7772N4112MKaiser Robert J · Eagle River, AKBuilt 1947 · S/N 12-3010N4113EEllenburg Sixth Family Limited Partnership · Anchorage, AKBuilt 1978 · S/N 18-7809071N41141Winit Matthew Clark · Woodland, WABuilt 1941 · S/N 5-1314N4114KNorth Florida Soaring Society Inc · Jacksonville, FLBuilt 1966 · S/N 25-4043N41153Herren Roger L · Clayton, ILBuilt 1941 · S/N 4-1617N41156Ruach Ministry · Dover, DEBuilt 1941 · S/N 5-1252N4115EBcs Properties LLC · Mead, COBuilt 1978 · S/N 18-7809072N4115HPeters Alan M · Arcola, TXBuilt 1947 · S/N 12-3548N4115ZCondict Wynn G · Saratoga, WYBuilt 1964 · S/N 18-8154N4116DLofstrom Caleb J · Wasilla, AKS/N 11-1580N4116EBlr Aviation LLC · Eagle River, WIBuilt 1978 · S/N 18-7809073N4116TRader Todd · Aurora, OHS/N 18-2381N4116ZEbinger Michael R · Mc Grath, AKBuilt 1964 · S/N 18-8155N41181Ryan Cynthia L · Anchorage, AKBuilt 1941 · S/N 5-1269N41186Flannery Bruce F · Gladstone, MIS/N 5-1287N4118ZSupercub1 LLC · Anchorage, AKBuilt 1964 · S/N 18-8159N4119EBigham David A · Phoenix, AZBuilt 1978 · S/N 18-7809077N4119ZSanderson Bryan D · Emmett, IDS/N 18-8161N411XMitchell Michael S · Missoula, MTBuilt 1962 · S/N 18-7851N4120ZZapotosky Joseph G · Seldovia, AKS/N 18-8164N41213Jenkins Michael D · Rigby, IDS/N 41636N4121MMusgrove Jimmy Wayne · Delta Junction, AKBuilt 1947 · S/N 12-3019N4121ZVisionary Adventures LLC · Anchorage, AKBuilt 1964 · S/N 18-8165N4122MAviation Management Group Inc · Noblesville, INBuilt 1947 · S/N 12-3020N41231Newton James K · Charles Town, WVBuilt 1941 · S/N 7884N41236Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1941 · S/N 5-1290N4123EDomke Victoria · Fairbanks, AKS/N 18-7809076N4123HEngler Eric M DBA · Cass City, MIS/N 15-6N4123ZOne2one LLC · Westminster, CABuilt 1965 · S/N 18-8186N4124EFuoss David J · Draper, SDBuilt 1978 · S/N 18-7809078N4125ZJordan David Thomas · Anchorage, AKBuilt 1964 · S/N 18-8191N4127HDyer Michael E · Live Oak, FLBuilt 1948 · S/N 15-11N4127MRand Richard E · Spearfish, SDBuilt 1947 · S/N 12-3024N4127ZMamrol Peter J · Anchorage, AKBuilt 1964 · S/N 18-8196N4128ZPierskalla Veronica Y · Wasilla, AKBuilt 1964 · S/N 18-8197N4129EBlase Benjamin J · Seeley Lake, MTBuilt 1978 · S/N 18-7809081N4129HWhichard Jordon Matthew · Grimesland, NCBuilt 1948 · S/N 15-13N4129ZWild About Nature LLC · Fairbanks, AKBuilt 1965 · S/N 18-8199N412KRRockdale Tiger Flight · Rockdale, TXS/N 15-112N412PCHelmen Harry W · Ruckersville, VABuilt 1956 · S/N 22-4311N412SCMay Bob L · Wedowee, ALBuilt 1946 · S/N 12-868N4131MHarris Jaqai N · Juneau, AKBuilt 1947 · S/N 12-3031N4131ZMacarthur Clinton W · Anchorage, AKBuilt 1965 · S/N 18-8201N41334Registration Pending · Saint Louis, MORegistration pendingS/N 5-1321N4133EHouse Larry A · Anchorage, AKBuilt 1978 · S/N 18-7809129
Back to AD 99-01-05 R1