Registered aircraft · 56

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

N103FBNorthern California Soaring Association · Byron, CABuilt 1984 · S/N 33930 N103MGWhite Sands Soaring Association Inc · Alamogordo, NMBuilt 1985 · S/N 33983-K-216 N103PRSeva Corp · Malibu, CABuilt 1984 · S/N 3852-K-98 N103RFTucson Soaring Club Inc · Sahuarita, AZBuilt 1985 · S/N 33921K156 N103SHSouthern California Soaring Academy Inc · Valencia, CABuilt 1986 · S/N 34051-K-281 N103TGRunaway 5 LLC · Wurtsboro, NYBuilt 1983 · S/N 3829 N103XSPrairie Thermals LLC · Brookings, SDBuilt 1982 · S/N 3745 N1113AThermal Inc · Rhinebeck, NYBuilt 1980 · S/N 3546 N117SZCarolina Soaring Association · Spartanburg, SCS/N 34074-K-304 N139BGPhiladelphia Glider Council Inc · Hilltown, PABuilt 1984 · S/N 33901-K-139 N140BGBenz Aviation LLC · Grand Haven, MIS/N 33902-K-140 N155WSSky Sailing Inc · Warner Springs, CAS/N 3786-K-64 N18AGJersey Ridge Soaring LLC · Blairstown, NJBuilt 1982 · S/N 3714 N217BGFreedom Wings International · Glenside, PAS/N 33984-K-217 N223WPRamirez Fidel M · Moriarty, NMS/N 3846-K-92 N228BGUtah Soaring Association Inc · Mapleton, UTBuilt 1985 · S/N 33995-K-228 N307BGRunway 5 LLC · Wurtsboro, NYS/N 34032-K-264 N3950AChapman John P · Long Beach, CABuilt 1983 · S/N 3793 N3981CNorthern California Soaring Association · Byron, CABuilt 1983 · S/N 3807 N4222WTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1983 · S/N 3804 N4446TWeller Steven C · Hummelstown, PABuilt 1983 · S/N 3824 N4446YUtah Soaring Association · Mapleton, UTBuilt 1983 · S/N 3825 N45748Central Indiana Soaring Society Inc · Yorktown, INS/N 3828 N4601MSouthern California Soaring Academy Inc · Valencia, CAS/N 3831 N4793NSb3 Asset Management LLC · Gilbert, AZBuilt 1984 · S/N 3842-K-88 N4794EBig Q Aviation · Midlothian, TXBuilt 1984 · S/N 3843-K-89 N4805RAgcsc Foundation Inc · Jacumba, CABuilt 1984 · S/N 3854-K-100 N4QDWichita Skylarks Soaring · Wichita, KSBuilt 1981 · S/N 3687-K-38 N5448WTucson Soaring Club Inc · Sahuarita, AZS/N 3869-K-110 N5448XCentral Ohio Soaring Assoc Inc · Marion, OHS/N 3870-K-111 N54553Ackley Richard F · Clearville, PAS/N 3872-K-113 N5462NCsa Foundation Inc · Wellington, COS/N 3875 N563SHTaylor Katrina A · Alamogordo, NMS/N 34021-K-253 N5QDPhiladelphia Glider Council Inc · Hilltown, PABuilt 1983 · S/N 3792 N62BGOklahoma Soaring Association · Mustang, OKBuilt 1981 · S/N 3649 N705MSAdrian Soaring Club Inc · Belleville, MIBuilt 1981 · S/N 3609 N767CSX-C Soaring Association Inc · Pensacola, FLBuilt 1985 · S/N 33994-K-227 N785GClosson Luke E Jr · Valdosta, GABuilt 1985 · S/N 33985-K-218 N786GCypress Soaring Inc · Hemet, CABuilt 1985 · S/N 33986-K-219 N793MZLakeland Aeroclub Inc · Lakeland, FLS/N 3877-K-115 N794GSandhill Soaring Club Inc · Brighton, MIS/N 34007-K-240 N795GArizona Soaring Inc · Maricopa, AZS/N 34006-K-239 N8013KJonas James P · Anaconda, MTBuilt 1982 · S/N 3702 N808XAntelope Valley Soaring Club · Llano, CAS/N 3815-K-76 N852BGField Drew · Dallas, TXBuilt 1985 · S/N 34014-K-247 N856BGTampa Bay Soaring Society Inc · Zephyrhills, FLS/N 34020-K-252 N898ASNatke Gregory I · Manlius, NYBuilt 1980 · S/N 3606 N901BGTexas Youth Flight Experience Foundation · Boerne, TXBuilt 1981 · S/N 3648 N907BGSoaring Dutchmen Inc · Wynnewood, PABuilt 1981 · S/N 3650 N923BGFreedoms Wings International Inc · Glenside, PAS/N 34037-K-268

Back to AD 86-17-08