OpenAirDocs.org
AD 92-07-07

Registered aircraft · 37

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

N114MSLynch James D · Scottsdale, AZBuilt 1976 · S/N 20131CN11CNSoar Wisc Inc · Little Canada, MNBuilt 1976 · S/N 20099N11VEKlein Flying Service Inc · Lawrenceville, ILBuilt 1976 · S/N 20150CN123MWWacker George F Trustee · Los Angeles, CABuilt 1976 · S/N 20123CN129AGieseke Joe R · Mount Juliet, TNBuilt 1975 · S/N 20079N12MRJonas James P Jr · Anaconda, MTBuilt 1975 · S/N 20038N12XMPhillips Gary J · Cumberland, MDBuilt 1975 · S/N 20114N130DCDowning Timothy J · Richfield Springs, NYBuilt 1984 · S/N 711N13LABarker Daniel B · Temecula, CAS/N 20097N168NLee Russell J · Newcastle, WABuilt 1976 · S/N 20116N1975SSines Keith L · Keyser, WVBuilt 1975 · S/N 20033N20EKCoucke David A · Nashville, INBuilt 1976 · S/N 20122CN20MMLedbetter Jason H · Ypsilanti, MIBuilt 1975 · S/N 20016N20PKJohnson Steven M · Waukesha, WIBuilt 1975 · S/N 20031N20SJReuter Gary G · Littleton, COBuilt 1975 · S/N 20064N21RLMcgee Terence A · Laguna Niguel, CABuilt 1976 · S/N 20117CN222PKRussell Matthew D · Chattaroy, WABuilt 1975 · S/N 20027N29JHTampa Bay Soaring Soceity Inc · Zephyrhills, FLBuilt 1975 · S/N 20061N2KVSides Matt E · Lonoke, ARBuilt 1975 · S/N 20036N30MGBrown Elijah E · Chino Valley, AZBuilt 1975 · S/N 20072N331RWahl John F · Edgewood, NMBuilt 1977 · S/N 20153CN338KPThompson Richard I · Evans City, PAS/N 20092N35WWEichhorn Tyler L · Ramona, CAS/N 20034N46JDKarst Max H · Seattle, WABuilt 1976 · S/N 20145CN47ZLovin Mark J · Longmont, COBuilt 1975 · S/N 20098N62390Bedell Christopher L · Santa Fe, NMBuilt 1974 · S/N 20011N6HLRegistration Pending · Pace, FLRegistration pendingBuilt 1975 · S/N 20057N6UAMileski William J · Ledyard, CTS/N 20149CN717ZZToro Christopher · Tampa, FLBuilt 1976 · S/N 20112N76WMIglesias Carolina · Waller, TXBuilt 1976 · S/N 20139CN77HZWisniewski Wit Tadeusz · Tucson, AZBuilt 1976 · S/N 20121CN77WPParzyk Roy E · Lake Stevens, WABuilt 1975 · S/N 20056N77XTCarpenter Bruce E · Monroe, NYBuilt 1976 · S/N 20100CN96128Conner John A Jr · Niceville, FLS/N 20146CN99136Wahl John F · Edgewood, NMS/N 20147CN995RJNeidert Melvin E · Ulysses, KSBuilt 1975 · S/N 20043N99WUMiller Robert G · New Carlisle, OHS/N 20055
Back to AD 92-07-07