Registered aircraft · 21

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

N116MAFsa Aerospace Inc Trustee · Wilmington, DEBuilt 1977 · S/N 029 N132LJAery Aviation LLC · Wilmington, DEBuilt 1977 · S/N 032 N136DHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1977 · S/N 036 N160GCC2d LLC · Cartersville, GAS/N 36A-030 N16FNGh Equipment LLC · Dover, DEBuilt 1976 · S/N 027 N17AValiair Limited Co Trustee · Casper, WYBuilt 1980 · S/N 046 N18FNGh Equipment LLC · Dover, DEBuilt 1974 · S/N 037 N20GJGlobal Jetcare Inc · Brooksville, FLS/N 026 N302EWAery Aviation LLC · Wilmington, DEBuilt 1976 · S/N 024 N31GJGlobal Jetcare Inc · Brooksville, FLBuilt 1976 · S/N 022 N32PAPhoenix Air Group Inc · Cartersville, GABuilt 1976 · S/N 025 N363PJPremier Jets Inc · Hillsboro, ORBuilt 1977 · S/N 038 N41GJGlobal Jetcare Inc · Brooksville, FLBuilt 1984 · S/N 055 N51GJGlobal Jetcare Inc · Brooksville, FLBuilt 1976 · S/N 018 N527PAPhoenix Air Group Inc · Cartersville, GABuilt 1976 · S/N 019 N545PAPhoenix Air Group Inc · Cartersville, GAS/N 36A-028 N56PAPhoenix Air Group Inc · Cartesville, GABuilt 1976 · S/N 023 N62PGPhoenix Air Group Inc · Cartersville, GABuilt 1977 · S/N 031 N71CKKalitta Charters LLC · Ypsilanti, MIBuilt 1977 · S/N 035 N81GJGlobal Jetcare Inc · Brooksville, FLBuilt 1981 · S/N 047 N99RSCasmos LLC · Wilmington, DES/N 039

Back to AD 2017-04-15