OpenAirDocs.org
AD 2011-01-03

Registered aircraft · 49

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:2011-01-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:2011-01-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.

N102GBCibotti Ricardo Roque · Bethesda, MDS/N 1424N102TLCentral Ms Soaring Society LLC · Brandon, MSS/N 1234N11UUnicorn Soaring Associates · Maple Valley, WABuilt 1976 · S/N 1369N124SSHutnick Michael C Jr · Bloomsburg, PABuilt 1976 · S/N 1172N125SSRousselle Kenneth D · Loveland, COBuilt 1976 · S/N 1311N126SSHigh Desert Soaring Club Inc · Redmond, ORBuilt 1976 · S/N 1169N127SSLakeland Aero Club Inc · Lakeland, FLBuilt 1976 · S/N 1170N128SSCardinal Flying LLC · Anderson, INBuilt 1976 · S/N 1211N129SSReeves Air Glide LLC · Moriarty, NMS/N 1212N130SSBoggs Gary Dean · Buckeye, AZS/N 1228N131SSPhiladelphia Glider Council Inc · Hilltown, PABuilt 1976 · S/N 1310N132SSNorthern California Soaring Assoc · Byron, CABuilt 1976 · S/N 1286N133SSAugust Aero LLC · Kalispell, MTS/N 1285N137SSGreater Houston Soaring Association · Needville, TXBuilt 1976 · S/N 1348N140SSNutmeg Soaring Association · Freehold, NYS/N 1350N141SSSmith Terence J · Bremerton, WAS/N 1351N142SSPittsburgh Soaring Association · Pittsburgh, PABuilt 1976 · S/N 1368N143SSBennett Wolfgang · Steamboat Springs, COBuilt 1976 · S/N 1370N145SSCollins Dennis L · Richland, WABuilt 1976 · S/N 1371N146SSHawkins Tim J · Albuquerque, NMBuilt 1976 · S/N 1372N147SSSteamboat Springs Soaring Association · Steamboat Springs, COS/N 1498N148SSKiss Laszlo · West Lafayette, INS/N 1499N149SSEllis Donald D W · Trenton, FLBuilt 1977 · S/N 1500N151SSSt Louis Soaring Association Inc · Saint Louis, MOBuilt 1977 · S/N 1501N152SSSwayze Henry S · Tunbridge, VTBuilt 1977 · S/N 1502N155SSTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1978 · S/N 1722N184SSChilcott Bret A · Derby, KSBuilt 1981 · S/N 5532SN20EDConrad Craig · Hickory, NCBuilt 1977 · S/N 1503N212JRRegistered aircraftBuilt 1975 · S/N 1011N22ZBCollegiate Soaring Association Inc · Greeley, COBuilt 1976 · S/N 1309N2LEHaggett William Thomas · Durham, NCBuilt 1976 · S/N 1312N305BGStreamline Aviation LLC · Battlefield, MOS/N 5642CBN36WWMahony John P · Ballston Spa, NYBuilt 1976 · S/N 1113N3950BSky Sailing Inc · Warner Springs, CABuilt 1983 · S/N 5607CBN3981AWalker Carol L · Ennis, TXBuilt 1983 · S/N 5610CBN4116MKennedy Cary A · Toano, VABuilt 1983 · S/N 5608CBN424BGSt Louis Soaring Association Inc · Saint Louis, MOS/N 5548CBN49JJFun Country Soaring · Valley City, OHBuilt 1983 · S/N 5606CBN603MLVan De Water Hendrik · Mount Pleasant, MIBuilt 1983 · S/N 5611CN69BGKing Steven · San Jacinto, CABuilt 1981 · S/N 5560SN75SWMitchell Jamie D · La Puente, CABuilt 1976 · S/N 1171N793GMid-Georgia Soaring Association Inc · Monroe, GAS/N 5636CBN851BGShipman Benny A · Las Vegas, NVS/N 5639 CBN853BGSouthern California Soaring Academy Inc · Valencia, CAS/N 5640 CBN91BGAndrews Kenneth S · Clinton Township, MIS/N 5529SN92BGTaylor-Barrett Jane · Tehachapi, CABuilt 1981 · S/N 5530 SN936BGMid-Atlantic Soaring Association Inc · Frederick, MDS/N 5649CBN93BGNeidert Melvin E · Ulysses, KSBuilt 1981 · S/N 5521 SN99361Kaounas Kostas T · Brookings, SDBuilt 1976 · S/N 1282
Back to AD 2011-01-03