Registered aircraft · 19

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

N1168UHeli-Flite Inc · Corona, CABuilt 1958 · S/N 58-1070 N126GWAircrane Inc · Winder, GABuilt 1959 · S/N 581124 N129NHSh1p Holdings LLC · Wichita, KSBuilt 1958 · S/N 58-855 N4247VSh1p Holdings LLC · Wichita, KSS/N 58-1547 N4XY5-State Helicopters Inc · Royse City, TXBuilt 1957 · S/N 58700 N504Vi 1 LLC · Brewster, WABuilt 1957 · S/N 57-1717 N504DHVan Surdam John R · Seneca, SCBuilt 1958 · S/N 58814 N506Vi 1 LLC · Brewster, WAS/N 14-8079 N589SSh1p Holdings LLC · Wichita, KSBuilt 1957 · S/N 58-0740 N58AHB&B Helos LLC · Perris, CABuilt 1956 · S/N 58-328 N58HFVi 1 LLC · Brewster, WABuilt 1957 · S/N 571692 N58HUVi1 LLC · Brewster, WABuilt 1963 · S/N 58-1575 N58NSVi 1 LLC · Brewster, WABuilt 1960 · S/N 58-1453 N58SAircrane Inc · Winder, GABuilt 1962 · S/N 58-1539 N6BL5 State Helicopters Inc · Royse City, TXBuilt 1962 · S/N 581567 N703SCVi 1 LLC · Brewster, WABuilt 1963 · S/N 581607 N85HJVi 1 LLC · Brewster, WAS/N 581716 N887Houston Aeronautical Heritage Society Inc · Houston, TXBuilt 1957 · S/N 58482 N9VY5-State Helicopters Inc · Fate, TXBuilt 1962 · S/N 581519

Back to AD 75-07-07