Skip to content

Registered aircraft · 95

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:88-12-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:88-12-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:88-12-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:88-12-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:88-12-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:88-12-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 N103NSNutmeg Soaring Assoc · Freehold, NYBuilt 1978 · S/N 3096 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 N107SEEvo 84 LLC · Bend, ORBuilt 1977 · S/N 3021 N1113AThermal Inc · Rhinebeck, NYBuilt 1980 · S/N 3546 N117SZCarolina Soaring Association · Spartanburg, SCS/N 34074-K-304 N11TACurry Robert B · Delphos, OHBuilt 1978 · S/N 3193 N1202ZTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1982 · S/N 3615 N125CCSilverado Soaring Inc · Roseville, CABuilt 1982 · S/N 3710 N126TASt Croix Eagles LLC · New Brighton, MNBuilt 1977 · S/N 3046 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 N158SSCounter Aviation Services LLC · Omaha, NEBuilt 1978 · S/N 3142 N160SSFault Line Flyers · Leander, TXBuilt 1978 · S/N 3143 N174SSFlying L Aircraft Inc · Fort Denaud, FLBuilt 1980 · S/N 3543 N18AGJersey Ridge Soaring LLC · Blairstown, NJBuilt 1982 · S/N 3714 N20HSCoffield Alan B · Canyon Lake, CABuilt 1984 · S/N 3860-K-106 N217BGFreedom Wings International · Glenside, PAS/N 33984-K-217 N21BRPiedmont Soaring Society · Clemmons, NCBuilt 1978 · S/N 3121 N223WPRamirez Fidel M · Moriarty, NMS/N 3846-K-92 N228BGUtah Soaring Association Inc · Mapleton, UTBuilt 1985 · S/N 33995-K-228 N2886AEvergreen Soaring · Lynnwood, WABuilt 1978 · S/N 3098 N307BGRunway 5 LLC · Wurtsboro, NYS/N 34032-K-264 N37WWTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1978 · S/N 3092 N3837MCross Country Soaring Inc · Lonsdale, MNBuilt 1983 · S/N 3764 N3950AChapman John P · Long Beach, CABuilt 1983 · S/N 3793 N39810Hoyle Clifford L · Pueblo, COBuilt 1983 · S/N 3813 N3981CNorthern California Soaring Association · Byron, CABuilt 1983 · S/N 3807 N3981HSt Louis Soaring Association Inc · Saint Louis, MOBuilt 1983 · S/N 3812 N4101MSandhill Soaring Club Inc · Brighton, MIBuilt 1983 · S/N 3796 N4113GLarson David A · Fort Pierce, FLBuilt 1983 · S/N 3794 N4115MTucson Soaring Club Inc · Sahuarita, AZBuilt 1983 · S/N 3799K N4222WTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1983 · S/N 3804 N422BGWindy City Soaring Association · Hinckley, ILBuilt 1982 · S/N 3711 N427BGAlbuquerque Soaring Club Inc · Albuquerque, NMBuilt 1982 · S/N 3739 N429BGCherryhill Flying Club LLC · Freetown, INBuilt 1982 · S/N 3737 N43JHHuntsville Soaring Assn · Brownsboro, ALBuilt 1983 · S/N 3806 N44259Sandhill Soaring Club Inc · Brighton, MIBuilt 1983 · S/N 3790 N4425YRudloff Uwe K · Lake Village, INBuilt 1983 · S/N 3820 N4426BN4426b LLC · Hood River, ORBuilt 1983 · S/N 3791 N4446TWeller Steven C · Hummelstown, PABuilt 1983 · S/N 3824 N4446WKnauff And Grove Inc · Julian, PABuilt 1983 · S/N 3822-K-81 N4446YUtah Soaring Association · Mapleton, UTBuilt 1983 · S/N 3825 N45748Central Indiana Soaring Society Inc · Yorktown, INS/N 3828

Back to AD 88-12-08