OpenAirDocs.org
AD 62-08-03

Registered aircraft · 3,907

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:62-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:62-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.

N1000THaughton Douglas L · Gig Harbor, WABuilt 1957 · S/N D-4980N100BHChopper Aviation LLC · Cahokia Heights, ILBuilt 1958 · S/N TD-130N100FBHoffman Swen · Sedalia, COBuilt 1963 · S/N D-7158N100TOwyhee Pacific LLC · Kalispell, MTBuilt 1960 · S/N TD-350N100TBAlexander Aviation LLC · Brighton, COBuilt 1963 · S/N CD-637N101BBPolson Taylor M · Killeen, TXBuilt 1959 · S/N D-6076N101HTWilder Bart M · Maryville, TNBuilt 1958 · S/N D-5722N1022THansen Jed D · Clark, SDS/N D-3144N1026BBazler Jack A Trustee · Boulder, COBuilt 1956 · S/N LH-163N102FAMedic Choppers LLC · Springdale, ARS/N TC-483N1037BSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1957 · S/N D-5311N103MPJoyce George E · Franklinville, NCS/N LF-50N103WWWilkin Richard G · Monticello, ILBuilt 1961 · S/N CD439N1040TTen Forty Tango LLC · Wichita, KSBuilt 1962 · S/N TC-318N104MMBaron 104mm LLC · Rohnert Park, CABuilt 1962 · S/N TC-289N105BMatthews George W · Hillsboro, OHBuilt 1956 · S/N D-4399N105XSaalwaechter John J · Lebanon, INBuilt 1960 · S/N D-6436N106BAnderson Martino G · Lakeland, FLBuilt 1955 · S/N D-4394N106NChenevert Eric M · Clarence, NYBuilt 1962 · S/N D7035N106VKenyon Joseph S · Fort Collins, COBuilt 1959 · S/N D-6009N10712Hall Air Inc · Weiner, ARBuilt 1961 · S/N TC-59N1077B85 Alpha Inc · Wilmington, DEBuilt 1957 · S/N D-4931N107VWHenning Nancy E · Hardinsburg, KYBuilt 1960 · S/N CD-71N107WSByers Mike L · Vista, CABuilt 1959 · S/N GH-107N108BCaturia Jeffrey T · Layton, UTBuilt 1955 · S/N D-4397N108GBLooney Jordan · Trumann, ARBuilt 1960 · S/N D-6422N109AKHarris Eric W Jr · Moncks Corner, SCBuilt 1956 · S/N D-4464N109SGreenair Corp · Memphis, TNBuilt 1958 · S/N TD-140N109VKeeling Rodney E · Pearce, AZBuilt 1960 · S/N CD-160N10EVCafiero Vincent · Haskell, OKBuilt 1955 · S/N D-4186N10GGMartinelli Alexander Joseph · Waco, TXBuilt 1947 · S/N D-1065N10RRLeonard Christopher S · Moravia, NYBuilt 1954 · S/N D-3706N110DBStarnes Robert D · Lavonia, GABuilt 1956 · S/N D-4646N1110CGriffith Danny E · Little Rock, ARS/N D-5117N1111ZHamburger Ronald O · Terrebonne, ORBuilt 1960 · S/N CD-276N1115YSmith Phillip · Arlington, TXS/N D-4248N111BWKnudsen Kent A · Rosenberg, TXBuilt 1954 · S/N D-3780N111JZPage Jeffrey C · Aledo, TXBuilt 1960 · S/N TC-48N111KFrizzell Kim F · Lakeville, MNBuilt 1961 · S/N D6786N111TXVirginia Air LLC · Wilmington, NCBuilt 1962 · S/N TC-283N111YBVanicek Nicholas Andrew · Whispering Pines, NCBuilt 1962 · S/N D-6962N112GBN112gb LLC · Oldsmar, FLBuilt 1964 · S/N CD796N1148TCorlett Samuel E · Fort Worth, TXBuilt 1958 · S/N D-5453N114FMoore Joe L · Cortez, COBuilt 1962 · S/N TC-347N114SIrby Darrell L · Keller, TXBuilt 1951 · S/N D-2709N1151XSummers Jayson V · Poway, CABuilt 1961 · S/N D-6705N115DLJ & S Consulting Solutions LLC · Middletown, DEBuilt 1961 · S/N TD-481N115MRRussell Keith M · Ivoryton, CTBuilt 1960 · S/N D-6394N116FTaylor John · Mammoth Spring, ARBuilt 1953 · S/N D-3488N117DPMccollum Michael T · Camarillo, CABuilt 1950 · S/N D-2321
Back to AD 62-08-03