Registered aircraft · 24

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

N105HHHaddock Flying Service Inc · Salters, SCS/N 1307 N106HHHaddock Flying Service Inc · Salters, SCS/N 1375 N11CUPockrus Pat B · Mineral Wells, TXBuilt 1957 · S/N 983 N26PEMshr Helicopter Service LLC · Chehalis, WAS/N 1327 N2770Lil Dawg Aviation · Wilmington, DES/N 1250 N28801Knutson Wayne R · Tioga, NDS/N 1218 N3269FYellowjacket Aviation LLC · Wenatchee, WABuilt 1976 · S/N 1144 N374HDreyer Elwain C · Cardington, OHS/N 1374 N47063Geco Inc · Wilmington, DEBuilt 1962 · S/N 1422 N47077Knutson Flying Service Inc · Tioga, NDBuilt 1957 · S/N 947 N493BNStimart Rene D Trustee · Harshaw, WIBuilt 1962 · S/N 1321 N58BABank Of Utah Trustee · Salt Lake City, UTBuilt 1957 · S/N 969 N62361Horizon Helicopters LLC · Toms River, NJBuilt 1975 · S/N 1067 N62455Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1962 · S/N 1438 N67065Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1957 · S/N 1023 N67155Horizon Helicopters LLC · Toms River, NJBuilt 1961 · S/N 1335 N686PSimply Living LLC · Fort Myers, FLS/N 592783 N689HSTexxon Resources Inc · Winter Park, FLBuilt 1959 · S/N 1169 N853BBSaile Daniel K · Skiatook, OKBuilt 1958 · S/N 1147 N920HAMshr Helicopter Service LLC · Chehalis, WABuilt 1962 · S/N 1361 N9299ZBryant Jonathan E · Joaquin, TXS/N 1150 N93456Ward Mark P · Wasilla, AKBuilt 1958 · S/N 1062 N94515Hiller Aircraft Corp · Firebaugh, CAS/N 1172 N94APSummit Helicopters Inc · Salem, VABuilt 1959 · S/N 1211

Back to AD 73-25-03