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.

N9314DCallahan Ashton G · Homer, AKBuilt 1958 · S/N 22-6325N9319DCloud Buster LLC · Bloomfield, IABuilt 1958 · S/N 22-6332N9321DNiec Casmier M · Clio, MIFirst renewal noticeBuilt 1958 · S/N 22-6334N9322DHitchcock Mark J · Scottsdale, AZBuilt 1958 · S/N 22-6335N9324DRegistered aircraftBuilt 1958 · S/N 22-6337N9332DMartin Clint R · Escondido, CABuilt 1958 · S/N 22-6352N9336DSitta Donald C · Farmington, NMS/N 22-6356N9337DNantz William G Jr · Raleigh, NCBuilt 1958 · S/N 22-6357N9349DFoote Jason D · Osakis, MNBuilt 1958 · S/N 22-6371N9350DWade Richard L II · Valdez, AKBuilt 1958 · S/N 18-6607N9352DPanther Paul A · Montrose, COS/N 18-6610N9355DHarris Chet A · Anchorage, AKS/N 18-6616N9356DHammond Dwight L · Burns, ORS/N 18-6617N9357DLeary Patrick W DBA · Lewistown, MTBuilt 1958 · S/N 18-6618N9359DFejes James Michael Jr · Anchorage, AKBuilt 1958 · S/N 18-6620N9363BAnderson James C · Anchorage, AKBuilt 1951 · S/N 18-1036N9364DSimmons John E · Anchorage, AKBuilt 1958 · S/N 18-6628N9365PHolly Gerald C Jr · Soldotna, AKBuilt 1980 · S/N 18-8109013N9366DLongboard Energy LLC · Broken Arrow, OKBuilt 1960 · S/N 18-6630N9368DMiller Jonathan L · Anchorage, AKBuilt 1958 · S/N 18-6633N9369DHackett Joel W · Georgetown, DEBuilt 1958 · S/N 18-6634N9373DWhite Matison R · Chugiak, AKBuilt 1958 · S/N 18-6638N9377PBoehmer Richard P · Machias, NYBuilt 1972 · S/N 18-8995N937APerkins Robert R · Walnutport, PABuilt 1951 · S/N 22-241N9381DRubbert Randy C · Reynolds, NDBuilt 1958 · S/N 18-6649N9384DDel Aero Service Inc · Delta, UTBuilt 1958 · S/N 18-6652N9386DWinters Danielle · Wasilla, AKBuilt 1958 · S/N 18-6656N9389DAirmotive Service LLC · Brigham City, UTBuilt 1958 · S/N 18-6661N938AJason Rozas · Eunice, LABuilt 1951 · S/N 22-243N9390DOcean Aerial Ads Inc · Ocean City, MDBuilt 1958 · S/N 18-6662N9391DSnider Scott E DBA · Turner, MTBuilt 1958 · S/N 18-6663N9393DAir Care Systems Inc · Lamar, COBuilt 1958 · S/N 18-6666N9395DScoot Air LLC · Alburgh, VTBuilt 1958 · S/N 18-6671N9396DDougherty Jennifer · Delta Junction, AKBuilt 1958 · S/N 18-6673N9398DAlpenglow Air LLC · Anchorage, AKBuilt 1958 · S/N 18-6680N9399DSparks Gary C · Valdez, AKBuilt 1958 · S/N 18-6681N93JTO Flanagan Clancy H · Chowchilla, CABuilt 1947 · S/N 11-1474N9401DBenesh Stephen P · Oshkosh, WIBuilt 1958 · S/N 22-6374N9401PGranite Aviation LLC · Belgrade, MTBuilt 1972 · S/N 18-8996N9403DKlingenberg Tim C · Udall, KSBuilt 1958 · S/N 22-6376N9405PDoyle Kevin M · Kenai, AKBuilt 1972 · S/N 18-8997N9406DMartin James D Sr · Coeur D Alene, IDS/N 22-6379N9406PHager Jerome P Jr · Frazee, MNBuilt 1972 · S/N 18-8998N9407DMatthew P R Mcdaniel · Oak Creek, WIBuilt 1958 · S/N 22-6381N9411DForsyth Bryan Oliver · Truckee, CABuilt 1958 · S/N 22-6385N9412DSchlamer Mark A · Campbellsport, WIBuilt 1958 · S/N 22-6386N9413DOl Blue LLC · Salt Lake City, UTBuilt 1958 · S/N 22-6387N9415DRogers Samuel · Le Roy, KSBuilt 1958 · S/N 22-6389N9419DKintz Dale K · Astoria, ORBuilt 1958 · S/N 22-6393N941MPHill John D · Reno, NVBuilt 1956 · S/N 22-4433
Back to AD 99-01-05 R1