OpenAirDocs.org
AD 2003-19-14 R2

Registered aircraft · 73

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

N74BHKansas Soaring Association · Wichita, KSS/N 3093N767CSX-C Soaring Association Inc · Pensacola, FLBuilt 1985 · S/N 33994-K-227N785GClosson Luke E Jr · Valdosta, GABuilt 1985 · S/N 33985-K-218N786GCypress Soaring Inc · Hemet, CABuilt 1985 · S/N 33986-K-219N787SFSoar Hawaii Foundation · Waialua, HIS/N 34118N792TWUtah Soaring Association Inc · Mapleton, UTBuilt 1978 · S/N 3184N794GSandhill Soaring Club Inc · Brighton, MIS/N 34007-K-240N795GArizona Soaring Inc · Maricopa, AZS/N 34006-K-239N8485WUtah Soaring Association · Mapleton, UTBuilt 1980 · S/N 3290N852BGField Drew · Dallas, TXBuilt 1985 · S/N 34014-K-247N856BGTampa Bay Soaring Society Inc · Zephyrhills, FLS/N 34020-K-252N906BGBrandywine Soaring Association · Hockessin, DEBuilt 1981 · S/N 3604N910BGCleveland Soaring Society Inc · Hartville, OHBuilt 1982 · S/N 3754N913GMarshall Soaring Club · Marshall, MIBuilt 1982 · S/N 3748N921GThermalator Soaring Association LLC · Wilmington, DEBuilt 1982 · S/N 3741N923BGFreedoms Wings International Inc · Glenside, PAS/N 34037-K-268N924BGPhiladelphia Glider Council · Hilltown, PAS/N 34038-K-269N925BGRidgetek Inc · Solana Beach, CAS/N 34044-K-275N926BGArizona Soaring Inc · Maricopa, AZBuilt 1986 · S/N 34045-K-276N928BGSailplane Adventures LLC · Santa Barbara, CAS/N 34047-K-278N930BGX-C Soaring Association Inc · Pensacola, FLS/N 34053-K-283N931BGMission Mountain Soaring Society · Ronan, MTS/N 34054-K-284N996TAdirondack Soaring Association Inc · Ballston Spa, NYBuilt 1978 · S/N 34130
Back to AD 2003-19-14 R2