OpenAirDocs.org
AD 59-10-03

Registered aircraft · 4,418

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-10-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-10-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.

N1000YBarkhimer James C · Iraan, TXBuilt 1954 · S/N 30999N1009PFerrier William T · Woodland, CABuilt 1958 · S/N 34994N100AWDe La Torre Alfonso Jr · Brownsville, TXBuilt 1956 · S/N 28479N100KHLefevers Adam · Pineville, KYS/N 28529N100MMFarmer Aviation LLC · Milan, MIS/N 33611N1023BLeguia Augusto A · Kathleen, GAS/N 28524N1027XHarper Shawn · Bayfield, COBuilt 1954 · S/N 31205N102CDrain Alan K · Columbus, MTS/N 30501N103PBBentley Jeffrey W · Kenmore, WABuilt 1957 · S/N 34372N1042GPorter David G · Stuart, FLS/N 36704N1044SHubbell Wallis E · Tucson, AZS/N 52829N1069LWilson Michael A · Everett, WABuilt 1956 · S/N 33633N106UMiha LLC · Dover, DEBuilt 1956 · S/N 32325N1073YGoedicke Walter H Jr · Bay Head, NJBuilt 1956 · S/N 28277N108EENorthwood Services Inc · Skwentna, AKBuilt 1956 · S/N 32505N108GWPope James D · Clarkston, WAS/N 32683N10BFCruz Keoni K · The Woodlands, TXBuilt 1958 · S/N 36672N10GCBanks Keith Allen · Salisbury, MDBuilt 1953 · S/N 30159N10URXtiri LLC · St George, UTBuilt 1955 · S/N 32184N10WQQuirion Paul J · Fairbanks, AKBuilt 1956 · S/N 33310N1100Souchet Brian · Fleming Island, FLBuilt 1956 · S/N 29178N111WFArnold Frank W · Senoia, GABuilt 1954 · S/N 31243N1124BAlaska Homestead Lodge Inc · Soldotna, AKBuilt 1957 · S/N 34259N1126AEberling Joan P · Central Point, ORBuilt 1977 · S/N 18265585N112NBillingsley Carl · Henderson, TXBuilt 1956 · S/N 28584N1144FBandit Air LLC · Stowe, PABuilt 1956 · S/N 33279N1171TCurrier Dustan A L · Fairbanks, AKS/N 30363N1177SRoss Robert S · Pigeon, MIBuilt 1958 · S/N 50177N1180BAom Aircraft LLC · Wilmington, DEBuilt 1953 · S/N 30115N1189RM9 180 LLC · Delhi, LAS/N 30698N119DHJohnson Peter L · Chico, CAS/N 36257N11FRMosley John E · Jackson, MSBuilt 1971 · S/N 18260761N11KTHilborn Rebecca M · Addison, NYBuilt 1956 · S/N 28593N11WHT T Aero LLC · Pauls Valley, OKBuilt 1956 · S/N 33447N1219PJersey Christopher M · Willis, TXBuilt 1977 · S/N 18265701N121FHamilton Wayne J · Mesa, AZBuilt 1956 · S/N 32353N1220CSky Bear Aviation LLC · Wilmington, DEBuilt 1956 · S/N 33008N1233BSutton Aircraft Salvage LLC · Palmer, AKS/N 51215N1234FSkydive New Hampshire LLC · Moab, UTS/N 33444N126AKRohl Shirley J · Anchorage, AKBuilt 1957 · S/N 32772N126SWollaston Dean E · Hazel Green, WIBuilt 1956 · S/N 33285N1284TWhite Wayne A · Loyalton, CABuilt 1959 · S/N 52016N131ELantz Herman D · Saint Clairsville, OHBuilt 1955 · S/N 31806N136TVReid Brian M · Boise, IDBuilt 1958 · S/N 51388N139BTTaylor Edward S · Billings, MTBuilt 1957 · S/N 29707N13FGBaum Group LLC · Shavertown, PABuilt 1957 · S/N 34271N13NPEvans Randall B Trustee · Fallon, NVBuilt 1954 · S/N 31225N1406MHeisler Jon S · Auburn, WABuilt 1954 · S/N 30851N144ARPaone Rebecca L · South Rockwood, MIS/N 28267N144JHTrachtenberg Dennis J · San Diego, CAS/N 31059
Back to AD 59-10-03