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.

N5485DN5485d LLC · Moses Lake, WAS/N 18-4753N5486HWhisonant Robert J · Winnett, MTBuilt 1950 · S/N 18-77N54879Shaw Brian · Granada, COS/N 25-7656025N54881Huntsville Soaring Club · Brownsboro, ALBuilt 1976 · S/N 25-7656027N5488ZLand Cecil J · Goshen, KYBuilt 1962 · S/N 22-9271N54898Central Indiana Soaring Society · Yorktown, INBuilt 1976 · S/N 25-7656032N5489HMcmahan Charles B · Gakona, AKBuilt 1950 · S/N 18-80N54904Quality Aviation Inc · Marana, AZS/N 25-7656033N54909Soaring Society Of Dayton Inc · Waynesville, OHBuilt 1976 · S/N 25-7656049N54914Csa Foundation Inc · Wellington, COBuilt 1976 · S/N 25-7656055N54915Mohawk Soaring Club Inc · Hoosick Falls, NYBuilt 1976 · S/N 25-7656056N54933Sammy Supercub LLC Series B · Reno, NVS/N 18-7709022N54938Lentsch Bill · Fairbanks, AKBuilt 1977 · S/N 18-7709024N54939Lang Madison S · Harper, TXBuilt 1976 · S/N 18-7709025N5493HBenson Steve J · Keenesburg, COS/N 18-84N5493ZMcnabb James A Trustee · Grove, OKBuilt 1962 · S/N 22-9278N5494ZLanham William B · Mineral Wells, TXBuilt 1962 · S/N 22-9279N5495HPeirce Kellie N · Mc Grath, AKBuilt 1950 · S/N 18-86N5495ZHayes Robert L · Chesapeake, VABuilt 1962 · S/N 22-9281N54968Kangas Kevin L · Fairbanks, AKBuilt 1976 · S/N 18-7709026N5496YAmundson Nancy F · Chugiak, AKBuilt 1952 · S/N 22851N54972Snider Scott E · Turner, MTBuilt 1976 · S/N 18-7709027N5497ZShira Daniel C · Homedale, IDBuilt 1962 · S/N 22-9283N5498KMitchell Dean R · Bay Village, OHS/N 22-8552N5498ZCunningham Florence Jean · Spokane Valley, WAS/N 22-9284N54990Hoffman Maurice M · Bowdle, SDBuilt 1976 · S/N 18-7709035N549DMCallaghan Jerry R · El Paso, TXBuilt 1961 · S/N 22-8500N549KJames Justin C · Palmer, AKBuilt 1959 · S/N 18-7179N54BCloud Nine Ventures LLC · Riverview, FLBuilt 1956 · S/N 22-4150N54BWWalker D B · Rougemont, NCBuilt 1976 · S/N 18-7609069N54ELCascade Air LLC · Trout Run, PABuilt 1989 · S/N 1809026N54LPPerry Jeffrey Kevin · Cumming, GABuilt 1954 · S/N 18-3928N54PPHancock Andrew M · Kettle Falls, WABuilt 1954 · S/N 22-2199N54YEBrown Lonnie S · Lone Jack, MOBuilt 1954 · S/N 18-3605N5500HMaxwell William P · Port Orange, FLBuilt 1949 · S/N 11-1001N5500ZPfc Aviation Repair Inc · Wallingford, CTS/N 22-9286N5509HShamrock Aviators LLC · Hamilton, OHBuilt 1949 · S/N 11-1011N5510HHarney Patrick Sean · Lowville, NYBuilt 1949 · S/N 11-1012N5511HKrech Greg L · Huron, SDBuilt 1949 · S/N 11-1013N5512ZShadow Aviation Inc · Fairbanks, AKBuilt 1964 · S/N 18-7845N5514ZWilkinson Bruce O · Williamsburg, VABuilt 1962 · S/N 22-9301N5515HFleurent John P · Stratham, NHBuilt 1949 · S/N 11-1017N5515ZLandrum Kelly T · Halifax, VABuilt 1962 · S/N 22-9302N5516HDejong Arie H · Maricopa, AZFirst renewal noticeS/N 11-1018N5517HEick Cody R · Fort Plain, NYBuilt 1948 · S/N 111019N551SCAoa Adventures LLC · Midvale, UTFirst renewal noticeS/N 18-945N5521ZTessenear James A · Hopewell, VABuilt 1962 · S/N 22-9309N5522HJ Mar Corp · New Castle, PABuilt 1949 · S/N 11-1024N5522ZWolfe Robert N · Rogers, TXBuilt 1962 · S/N 22-9310N5528HHandly William A · Arcola, MSBuilt 1949 · S/N 11-1031
Back to AD 99-01-05 R1