Registered aircraft · 103

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

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, UTFirst renewal noticeBuilt 1983 · S/N 3825 N45748Central Indiana Soaring Society Inc · Yorktown, INFirst renewal noticeS/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 N487GCPhiladelphia Glider Council Inc · Hilltown, PABuilt 1989 · S/N 34123 N4QDWichita Skylarks Soaring · Wichita, KSBuilt 1981 · S/N 3687-K-38 N53608Seminole Flying & Soaring Inc · Clermont, FLBuilt 1984 · S/N 3861-K-107 N5361VPhiladelphia Glider Council · Hilltown, PABuilt 1984 · S/N 3863 N5364GWhite Sands Soaring Foundation Inc · Alamogordo, NMBuilt 1984 · S/N 3865 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 N672HFun Country Soaring · Wellington, OHBuilt 1983 · S/N 3777 N705MSAdrian Soaring Club Inc · Belleville, MIBuilt 1981 · S/N 3609 N72EJLakeland Aero Club Inc · Lakeland, FLBuilt 1979 · S/N 3253-T-30 N74BHKansas Soaring Association · Wichita, KSS/N 3093 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 N787SFSoar Hawaii Foundation · Waialua, HIS/N 34118 N792TWUtah Soaring Association Inc · Mapleton, UTBuilt 1978 · S/N 3184 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 N8485WUtah Soaring Association · Mapleton, UTBuilt 1980 · S/N 3290 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 N906BGBrandywine Soaring Association · Hockessin, DEBuilt 1981 · S/N 3604 N907BGSoaring Dutchmen Inc · Wynnewood, PABuilt 1981 · S/N 3650 N910BGCleveland Soaring Society Inc · Hartville, OHBuilt 1982 · S/N 3754 N913GMarshall Soaring Club · Marshall, MIBuilt 1982 · S/N 3748 N921GThermalator Soaring Association LLC · Wilmington, DEBuilt 1982 · S/N 3741 N923BGFreedoms Wings International Inc · Glenside, PAS/N 34037-K-268 N924BGPhiladelphia Glider Council · Hilltown, PAS/N 34038-K-269 N925BGRidgetek Inc · Solana Beach, CAS/N 34044-K-275 N926BGArizona Soaring Inc · Maricopa, AZBuilt 1986 · S/N 34045-K-276 N928BGSailplane Adventures LLC · Santa Barbara, CAS/N 34047-K-278

Back to AD 2004-08-13