OpenAirDocs.org
AD 48-31-01

Registered aircraft · 82

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:48-31-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:48-31-01')
  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.

N101PEDemarco Eugene J · New Orleans, LABuilt 1944 · S/N 1386N10BQDunigan Patrick II · Jackson, MIBuilt 1943 · S/N 1327N111WHamilton Steven T · Reno, NVBuilt 1945 · S/N 1420N13122Alaska Aviation Museum · Anchorage, AKBuilt 1943 · S/N 1312N1340VClaire Aviation · Wilmington, DEBuilt 1941 · S/N 1228N135MGOld Crow LLC · Columbus, OHBuilt 1944 · S/N 1389N141RCompton Steven J · Anchorage, AKBuilt 1944 · S/N 1378N144SLBank Of Utah Trustee · Salt Lake City, UTS/N 1215N1595VBlocher Steven W Jr · Moscow, IDS/N 1319N17481Ball Fred E · College Place, WABuilt 1944 · S/N 1360N199THarder Michael U · Dillingham, AKBuilt 1941 · S/N 1213N1ASBeacon West LLC · Hayden Lake, IDBuilt 1941 · S/N 1230N23456Hangar One Inc · Wilmington, DES/N 1270N244GWWhite Wings LLC · Anchorage, AKBuilt 1947 · S/N 1473N25DFHough Robert M · Windham, NHBuilt 1943 · S/N 1306N299CNEastern Shore Helicopters Inc · Labelle, FLS/N 1299N302Alaska Bush Leasing LLC · Anchorage, AKBuilt 1943 · S/N 1294N33QYanks Air Museum · Baldwin Park, CAS/N 1398N350GWDalks Leasing Inc · Wilmington, DEBuilt 1954 · S/N 4N37186Perry James D · Monroe, WAS/N 1236N3NOlson Ventures LLC · Golovin, AKBuilt 1946 · S/N 1471N402ECWaterlanding LLC · Missoula, MTBuilt 1946 · S/N 1452N402EGLost In Time LLC · Rochester, NYBuilt 1946 · S/N 1444N403ERegistration Pending · Rochester, NYRegistration pendingBuilt 1944 · S/N 1300N404QMezrah Realty Corp Inc · Tampa, FLS/N 1388N414UIronworks Air LLC · Rogers, MNBuilt 1945 · S/N 1427N41988Sky High Investments LLC · Greenwood, INBuilt 1945 · S/N 1419N41990R H K Of Kansas Inc · Overland Park, KSBuilt 1945 · S/N 1421N41993Minta Inc · Pilot Point, AKBuilt 1945 · S/N 1424N41GWNorthern Flyer LLC · Anchorage, AKBuilt 1941 · S/N 1235N440GWRace Aviation Inc · Northampton, MABuilt 1945 · S/N 1410N444MTriple 4 Mike LLC · Crystal Bay, NVS/N 1411N4492NUsibelli Joseph Emil Trustee · Fairbanks, AKS/N 1298N44CHRunyon Aviation LLC · Fort Worth, TXBuilt 1946 · S/N 1454N44DWGrumman Widgeon LLC · Missoula, MTS/N 1381N44VWVan Wagnen Brian J · Jackson, MIBuilt 1945 · S/N 1408N45PVGuyton Thomas J · Toledo, OHBuilt 1944 · S/N 1380N4617NBurgan Grover W · Jacksonville, FLBuilt 1944 · S/N 1364N474GWFour Seven Four Golf Whiskey LLC · Ponte Vedra Beach, FLBuilt 1948 · S/N 1474N47CDickey Tod V · Phoenix, AZS/N 1371N480AKMartin Timothy R · Anchorage, AKBuilt 1942 · S/N 1346N521YTDelcavu LLC · Dover, DEBuilt 1943 · S/N 1311N52833Mcbride Kenneth B · San Martin, CAS/N 1374N540MWTaylor Steven · Riverdale, MIBuilt 1943 · S/N 1324N54VTRegistered aircraftS/N 1277N575L575 LLC · Fairbanks, AKS/N 1463N58837Forsberg Edwin E · Elk Grove, CAS/N 1337N62000Clark Nikita C · Ontario, ORS/N 1292N62096Lost Aviators Of Pearl Harbor LLC · Bellingham, WABuilt 1944 · S/N 1393N63350Failing Amanda R · Wasilla, AKBuilt 1944 · S/N 1387
Back to AD 48-31-01