OpenAirDocs.org
AD 59-08-03

Registered aircraft · 155

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

N1004PVankirk Malcolm R · Frederick, MDBuilt 1954 · S/N 23-6N1017PZeivogel Jeanine · Gulf Shores, ALBuilt 1954 · S/N 2319N1033PProfessional Pilots Inc · Lowell, INBuilt 1954 · S/N 23-35N103RSZielke Michael M · Chuluota, FLBuilt 1957 · S/N 23-1165N105EBHardy Randall B · Argyle, TXBuilt 1956 · S/N 23-460N1065PChisum Robert · Lorenzo, TXS/N 23-75N1071PFlying Circus Aircraft LLC · Manitou Beach, MIBuilt 1954 · S/N 23-82N1089PDetert Bradley · Valparaiso, INBuilt 1954 · S/N 23-98N1116PSale Reported · Scottsville, VASale reportedBuilt 1955 · S/N 23-126N1123PRegistration Pending · Flint Hill, VARegistration pendingS/N 23-133N1131PDBA Congdons Aviation Service · Anchorage, AKS/N 23-141N1132PR & S Stuart Co Inc · Wilmington, DEBuilt 1955 · S/N 23-142N1134PSutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 23-146N1140PCromley Amanda J · Lewisburg, PABuilt 1955 · S/N 23-152N1158PLorenzo Walker Institute Of Tech · Naples, FLBuilt 1955 · S/N 23-171N1166PDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1955 · S/N 23-180N1167PCascadia Air Ventures Inc · Winlock, WABuilt 1955 · S/N 23-181N1172PSteed William B · Winnsboro, SCS/N 23-175N1174PHardin John M · Terrell, TXBuilt 1955 · S/N 23-188N1189PParks Eric · Matthews, NCBuilt 1955 · S/N 23-203N1197PPenley Steven A · Corinth, TXBuilt 1955 · S/N 23-212N1207PN73481 LLC · Ault, COBuilt 1955 · S/N 23-223N1210PRegistration Pending · Independence, MORegistration pendingBuilt 1955 · S/N 23-226N1215PTucker Robert B · Melba, IDBuilt 1955 · S/N 23-234N1217Pendley Rory G · Torrance, CABuilt 1955 · S/N 23-237N1220BWash Steven M · Austin, TXBuilt 1957 · S/N 23-1161N1231PTwin Oaks Airpark Inc · Hillsboro, ORBuilt 1955 · S/N 23-251N1234PThomas Steven E · Libertyville, ILBuilt 1955 · S/N 23-255N123PJacobs Michael · Jay, OKBuilt 1955 · S/N 23-397N1255PJones Jamie · Grants Pass, ORS/N 23-281N1271PWendt Aero LLC · Newberg, ORBuilt 1955 · S/N 23-301N1273PMatthews Grover C · Fairborn, OHBuilt 1955 · S/N 23-304N1292PEm Turbines Corp · Fort Lauderdale, FLS/N 23-327N1305PParkhill Clifton A Jr Trustee · Oxnard, CABuilt 1955 · S/N 23-345N1308BHopewell Jeffrey D · Temple, TXBuilt 1955 · S/N 23-340N1316PMatthews Grover C · Hardinsburg, KYBuilt 1955 · S/N 23-356N1317PWhite Christopher N · Clearwater, FLBuilt 1955 · S/N 23-357N1319PCanter Russell L · Enterprise, KSBuilt 1955 · S/N 23-360N1334PN1334p LLC · Titusville, FLBuilt 1955 · S/N 23-379N1335PRiggin Flight Service Inc · Madison, SDS/N 23-380N1344PCrist Charles E · Waxahachie, TXBuilt 1955 · S/N 23-390N1352PHouse Travis · Bristow, VABuilt 1955 · S/N 23-401N1367PBuzzard Air Service LLC · Carleton, MIBuilt 1956 · S/N 23-416N1381PObermueller Frederick J · Milford, NJBuilt 1956 · S/N 23-431N1384PHanson Roddy L · Butterfield, MNBuilt 1956 · S/N 23-434N1393PSeymour Lori L · Woodstock, GAS/N 23-445N1432MLarson Sean P · Fairbanks, AKS/N 23-432N1438PTri Rotor Spray & Chemical · Ulysses, KSS/N 23-496N1452PSorenson Mark A · Senoia, GABuilt 1956 · S/N 23-515N1454PLansing Community College · Mason, MIBuilt 1956 · S/N 23-517
Back to AD 59-08-03