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.

N9666PKenmore Air Harbor LLC · Kenmore, WABuilt 1974 · S/N 18-7509011N9667DAppling Justin Glenn · Amarillo, TXS/N 22-6583N9667PNigus Brett Alan · Fairbanks, AKBuilt 1974 · S/N 18-7509012N9669GSweet Anthony E · Peyton, COS/N 18-2379N966AMattson Edward B · Quincy, WABuilt 1951 · S/N 22-271N9670PMoore Performance Aircraft LLC · Jenks, OKBuilt 1974 · S/N 18-7509014N9671PSmith Gregory · Lewistown, MTBuilt 1974 · S/N 18-7509025N9674PTexas Dakota Partners Ltd · Rankin, TXBuilt 1974 · S/N 18-7509017N9675PMiller Judith A · Homer, AKBuilt 1976 · S/N 18-7609020N9676PLoose Jason G · Harlowton, MTBuilt 1974 · S/N 18-7509021N9678PSvancara Ty Robert · Moses Lake, WAS/N 18-7509019N9679PAnderson Kevin L Trustee · Big Lake, AKS/N 18-7509022N9680DGoundry George D · Sammamish, WABuilt 1959 · S/N 22-6597N9680PB407 LLC · Seattle, WABuilt 1974 · S/N 18-7509023N9681DLynch Sean L · Brighton, ILBuilt 1959 · S/N 22-6598N9681PHibbert Kim O · Anchorage, AKBuilt 1974 · S/N 18-7509018N9682PHutchison Don D · Wounded Knee, SDBuilt 1974 · S/N 18-7509024N9683DSmith James A · Lyle, WAS/N 22-6600N9683PWarthog Flying Service Inc · Stuttgart, ARS/N 18-7509026N9684PNotti Jae A · Otter, MTBuilt 1974 · S/N 18-7509027N9685DPadgett Matthew K · Star City, ARBuilt 1959 · S/N 22-6602N9685PJones Victor E · Cordova, AKBuilt 1975 · S/N 18-7609022N9686PT-6 Warbird LLC · Tulsa, OKFirst renewal noticeBuilt 1975 · S/N 18-7509028N9687PWard Don D · Glennallen, AKBuilt 1974 · S/N 18-7509031N9688DPetersohn Jeffrey A · Ellijay, GAS/N 22-6605N9688PBillmayer James J · Kalispell, MTBuilt 1975 · S/N 18-7509032N9689DFoster Stephen G · Grand Ledge, MIBuilt 1959 · S/N 22-6606N9689PJohnson Terry M · Wolfforth, TXS/N 18-7509034N968AMasura Judith E · Glenoma, WABuilt 1951 · S/N 22-280N968DHAlarado Aviation LLC · Chugiak, AKBuilt 1978 · S/N 18-7809138N968SWLessor Mark E · Boise, IDBuilt 1953 · S/N 18-1444N9690DHoffner Flying Inc · Yankton, SDBuilt 1959 · S/N 18-6791N9691DSmith Daryl W · Winifred, MTBuilt 1958 · S/N 18-6792N9691PPeterson Air LLC · Chisago City, MNS/N 18-7709040N9692DVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1959 · S/N 18-6800N9692PGlass City Aviation Services LLC · Wilmington, DES/N 18-7509036N9693DNewberg Curtis · Willmar, MNBuilt 1958 · S/N 18-6794N9693PStewart Jonah M · Wasilla, AKBuilt 1975 · S/N 18-7509037N9694PBocek James C · Sheridan, WYBuilt 1975 · S/N 18-7509038N9695DPc Flyers LLC · Post Falls, IDBuilt 1959 · S/N 18-6798N9695PTop Hand Inc · Laurel, MTBuilt 1975 · S/N 18-7509039N9697DWarner Carl P · Lindley, NYBuilt 1959 · S/N 22-6607N9697PDubious Adventures II LLC · Big Lake, AKBuilt 1975 · S/N 18-7509040N96DVan Wagner Aerial Media LLC · Hollywood, FLS/N 183810N96DCVertical Horizon Aviation LLC · Sandown, NHBuilt 1960 · S/N 18-7284N96SCLarson Richard A · Lawndale, CABuilt 1989 · S/N 1809032N9701DCharles Benjamin L · Willow, AKBuilt 1959 · S/N 22-6612N9701PTucson Soaring Club Inc · Sahuarita, AZBuilt 1975 · S/N 25-7556012N9702DAdams Carl B · Albuquerque, NMBuilt 1959 · S/N 22-6613N9702PHall Charles R · Ennis, MTBuilt 1975 · S/N 18-7509134
Back to AD 99-01-05 R1