Registered aircraft · 275

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

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:76-13-11-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-13-11-R1') ORDER BY n_number

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

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:76-13-11-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-13-11-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N2656HWurtsboro Airpark LLC · Wurtsboro, NYS/N 436 N2659HKutztown Aviation Service Inc · Germansville, PABuilt 1976 · S/N 459 N2668HSky Soaring Inc · Hampshire, ILBuilt 1976 · S/N 438 N2677HBermuda High Soaring School Inc · Lancaster, SCBuilt 1977 · S/N 465 N2677NFreeland Christopher G · Brownwood, TXS/N 243 N2690HEastern Shore Helicopters Inc · Labelle, FLBuilt 1978 · S/N 510 N2692HPiercy Ronald S · Moses Lake, WABuilt 1978 · S/N 526 N2706HBeyer Ricky B · Lowville, NYBuilt 1976 · S/N 456 N2717ZWroe Daniel C · Denton, MDBuilt 1964 · S/N 170 N2723ZOwen Bryce C · Solvang, CABuilt 1964 · S/N 179 N2724HN2724h Aviation Services LLC · Colorado Springs, COBuilt 1978 · S/N 504 N2727ZMorgan III Robert E · Destin, FLBuilt 1964 · S/N 181 N2743HSugarbush Soaring Association Inc · Warren, VTBuilt 1978 · S/N 503 N2745HBarrett Jane T · Tehachapi, CABuilt 1978 · S/N 525 N2747ZMidwestern Soaring Association · Peculiar, MOBuilt 1964 · S/N 195 N2748RGoebel James W · Loveland, OHBuilt 1963 · S/N 168 N2749Z2019 Glider LLC · Pipersville, PABuilt 1964 · S/N 197 N2750HChilhowee Soaring Association Inc · Benton, TNBuilt 1976 · S/N 450 N2753ZDavenport Peter B · Harrington, WABuilt 1964 · S/N 208 N2761RCarlton Koby A · Warsaw, KYBuilt 1963 · S/N 174 N2762RWilliams Jimmy Z · Sherman, TXBuilt 1963 · S/N 175 N2764ZTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1964 · S/N 210 N2772ZWright Alan L · Independence, ORBuilt 1965 · S/N 215 N2784ZAerodrome Services LLC · Maple Park, ILS/N 218 N2793HJourneys Aviation Inc · Boulder, COBuilt 1978 · S/N 533 N2805HCivil Air Patrol · Maxwell Afb, ALBuilt 1978 · S/N 515 N2811HHamilton Soaring Club Inc · Hamilton, TXBuilt 1978 · S/N 511 N2832HHardy Truly C · Southampton, NYBuilt 1978 · S/N 532 N2838HKutztown Aviation Service Inc · Germansville, PAS/N 546 N2848HGroshel Joseph C · State College, PABuilt 1978 · S/N 538 N2890HCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 550 N2905HHigh Flights Soaring Club · Peyton, COBuilt 1979 · S/N 545 N2930HConnecticut Soaring Association · New London, CTBuilt 1978 · S/N 530 N2953HCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 553 N2984HTidewater Soaring Society · Windsor, VABuilt 1979 · S/N 560 N2985HArizona Soaring Inc · Maricopa, AZBuilt 1979 · S/N 555 N2987HSterling Flyers LLC · Lehi, UTS/N 559 N329SSSuperior Soaring LLC · Scottsdale, AZBuilt 1973 · S/N 266 N33923Las Vegas Valley Soaring Assoc · Jean, NVBuilt 1975 · S/N 413 N33928Flying L Aircraft Inc · Fort Denaud, FLBuilt 1975 · S/N 408 N33929High Flights Soaring Club Inc · Peyton, COBuilt 1975 · S/N 411 N33933Hershey Flying Service Inc · David City, NEBuilt 1975 · S/N 403 N33941Gehrlein Rodney L · Waterford, PABuilt 1975 · S/N 401 N33962Soaring Club Of Houston · Waller, TXBuilt 1974 · S/N 362 N33966Flight Experience For Youth · Warren, VTBuilt 1974 · S/N 366 N33968Franconia Soaring Assoication Inc · Franconia, NHBuilt 1974 · S/N 368 N33983Jersey Ridge Soaring LLC · Blairstown, NJBuilt 1975 · S/N 383 N34215Burbank Franklin R · Ocala, FLBuilt 1975 · S/N 415 N34292Registration Pending · Tehachapi, CARegistration pendingBuilt 1975 · S/N 412 N34298Frasca Air Museum · Urbana, ILBuilt 1976 · S/N 420

Back to AD 76-13-11 R1