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:2005-26-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:2005-26-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:2005-26-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:2005-26-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:2005-26-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:2005-26-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.

N10067Safer Medical Of Mt · Fort Benton, MTBuilt 1972 · S/N 2276 N1102Essential Flight Operations LLC · Arlington, WABuilt 1964 · S/N 1918-19 N114LAPike Mark D · Las Vegas, NVBuilt 1961 · S/N 1623 N131HAHigh Altitude Helicopters Inc · Brewster, WABuilt 1993 · S/N 1318/43 N174DBGulf Coast Helicopters Inc · Crowley, LABuilt 1961 · S/N 1593 N225RWDufton Charles S · North Stonington, CTBuilt 1959 · S/N 1312 N238HAHigh Altitude Helicopters Inc · Brewster, WABuilt 1976 · S/N 2438 N297CJInternational Air Services Inc Trustee · Carson City, NVBuilt 1963 · S/N 1847 N313JFBrekken Chris · Prescott, WIBuilt 1961 · S/N 1652 N315BFLama French Alps Inc Trustee · Wilmington, DEBuilt 1960 · S/N 05 N315BRInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 2621 N315CHFresh Heli LLC · Gillette, WYBuilt 1976 · S/N 2456 N316BJLama French Alps Inc Trustee · Wilmington, DEBuilt 1969 · S/N 1611 N316DJInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 2505 N316TXRosenberg Adrian · Laupahoehoe, HIS/N 2191 N3599DAero Tech Helicopters LLC · Kingstree, SCBuilt 1979 · S/N 2579 N45VXGospel Ministries International Inc · Collegedale, TNBuilt 1959 · S/N 1229 N483BASomebeech LLC · Prescott Valley, AZBuilt 1979 · S/N 2558 N55963International Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 2428 N57948Dodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 2628 N596JPAerospace Trust Management LLC Trustee · Wilmington, DES/N 2652 N605DMEast Coast Classic Jets Inc · Rochester, NYBuilt 1963 · S/N FM-47 N8655Rosenburg Adrian · Laupahoehoe, HIBuilt 1970 · S/N 1728 N9007NNorthwest Helicopters LLC · Olympia, WABuilt 1978 · S/N 2542

Back to AD 2005-26-13