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.

N38613Strassberger Karl E · Williamstown, VTBuilt 1941 · S/N 7145N38616Scott Robert Gizzie · Johnson City, TNBuilt 1941 · S/N 7148N38618Giron Lawrence N · Anchorage, AKS/N 7159N3861PDellinger Jeremiah · Eagle River, AKBuilt 1955 · S/N 22-3553N3862ZAdams Bob L · Eagle River, AKBuilt 1961 · S/N 18-7637N386331941 Historical Aircraft Group Museum DBA · Geneseo, NYS/N 5-1016N38634Engler Eric M DBA · Cass City, MIBuilt 1941 · S/N 5-1018N3863MClark Thomas M · Fiskdale, MABuilt 1947 · S/N 12-2773N38640Mccutchan Anthony L · Collinsville, OKBuilt 1941 · S/N 5-1025N38643Dykstra Dennis D · Marion, SDS/N 5-1028N38645Wright Cecil A · Sanford, FLS/N 5-1030N38646Murphree David A · Lake Saint Louis, MOBuilt 1941 · S/N 5-1031N38647Neidert Melvin E · Ulysses, KSBuilt 1941 · S/N 5-1032N38648Beranek Jim · Cottage Grove, ORBuilt 1941 · S/N 5-1033N3864ZHorizon Transportation And Rentals LLC · Phoenix, AZBuilt 1961 · S/N 18-7641N38660Southern Ohio Tractor LLC · Hillsboro, OHBuilt 1941 · S/N 5-1049N3866MKirk Robert C · Chandler, AZBuilt 1947 · S/N 12-2775N3866PWateractive43 LLC · Auburn, CABuilt 1955 · S/N 22-3558N3866ZForestry Aero LLC · Norwood, LABuilt 1961 · S/N 18-7647N38678Dillen William M · Fairview, PABuilt 1941 · S/N 7187N3867MBoese Bruce A · Modesto, CABuilt 1947 · S/N 12-2776N3867ZGaller Frank G · Elysian, MNBuilt 1961 · S/N 18-7648N38686Jones Gordon B · Medford, WIS/N 7194N38687Geiger William G · Park City, UTBuilt 1948 · S/N 7195N38693Pevey David M · Mcdonough, GABuilt 1941 · S/N 7201N38697Klosterman Aviation LLC · Celina, OHS/N 51056N38698Worldwide Technical Services Inc · Bulger, PABuilt 1941 · S/N 5-1055N3869MJohnson Don S · Sterling, AKBuilt 1947 · S/N 12-2784N386ABPlane And Simple Leasing LLC · Delano, MNBuilt 1966 · S/N 25-3790N38707Nixon David W · Portland, ORBuilt 1941 · S/N 5-1063N3870MSloan William R · Anchorage, AKBuilt 1947 · S/N 12-2789N3870PPlane Fun Inc Tr Trustee · Snellville, GABuilt 1955 · S/N 22-3563N38712Thistlethwaite Edward A Jr · Sunset, LABuilt 1941 · S/N 51068N38719Ford Brendon S · Weimar, TXS/N 5-1074N3871MProut Paul D · Eveleth, MNBuilt 1947 · S/N 12-2886N3872CRoberts Michael J · Hood River, ORFirst renewal noticeBuilt 1951 · S/N 18-763N3872ZHale Mitchell D · Chugiak, AKBuilt 1961 · S/N 18-7657N38737Neal Alan B · Cherry Valley, CAS/N 7208N3873ZSchok Richard N Jr · Fairbanks, AKBuilt 1961 · S/N 18-7661N38743Adams Eddie · Senath, MOBuilt 1941 · S/N 7220N38747Frazier Forrest Alan · Augusta, MOBuilt 1941 · S/N 7229N3874MGott Michael · Fairbanks, AKBuilt 1947 · S/N 12-2785N3874PPearson Joshua J · Unionville, MOS/N 22-3567N3874ZSlinkard Justin W · Bakersfield, CABuilt 1961 · S/N 18-7734N38755Sikes Robert J · Valdosta, GABuilt 1940 · S/N 7232N38759Costanza Joseph V · Marlton, NJBuilt 1941 · S/N 7236N3875MSky Ad Inc · Greenwich, CTBuilt 1947 · S/N 12-2786N3875PLonnevik Dennis F · Bigfork, MTBuilt 1955 · S/N 18-4701N3876PBreen George R · East Falmouth, MABuilt 1956 · S/N 18-4702N3877PBranson Derrick · Seward, AKBuilt 1955 · S/N 18-4703
Back to AD 99-01-05 R1