AD 2005-07-22
Registered aircraft · 87
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
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-07-22')
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-07-22')
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-07-22') 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-07-22') 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.
N778RHWilmington Trust Co Trustee · Wilmington, DEN779RNWilmington Trust Co Trustee · Wilmington, DEN780AHWilmington Trust Co Trustee · Wilmington, DEN780NCCommuteair LLC · North Olmsted, OHN781EJWilmington Trust Co Trustee · Wilmington, DEN782SMWilmington Trust Co Trustee · Wilmington, DEN783LCWilmington Trust Co Trustee · Wilmington, DEN784DPWilmington Trust Co Trustee · Wilmington, DEN785BRWilmington Trust Co Trustee · Wilmington, DEN786SMWilmington Trust Co Trustee · Wilmington, DEN787BPWilmington Trust Co Trustee · Wilmington, DEN788CJWilmington Trust Co Trustee · Wilmington, DEN789SSWilmington Trust Co Trustee · Wilmington, DEN790MKWilmington Trust Co Trustee · Wilmington, DEN791DKWilmington Trust Co Trustee · Wilmington, DEN792JBWilmington Trust Co Trustee · Wilmington, DEN794JHWilmington Trust Co Trustee · Wilmington, DEN798CCWilmington Trust Co Trustee · Wilmington, DEN810MDUmb Bank Na Trustee · Salt Lake City, UTN815MDUmb Bank Na Trustee · Salt Lake City, UTN818MDUmb Bank Na Trustee · Salt Lake City, UTN823MDUmb Bank Na Trustee · Salt Lake City, UTN824MDUmb Bank Na Trustee · Salt Lake City, UTN855RWRepublic Airways Inc · Carmel, INN857RWRepublic Airways Inc · Carmel, INN860RWUmb Bank Na Trustee · Salt Lake City, UTN861RWRepublic Airways Inc · Carmel, INN862RWRepublic Airways Inc · Carmel, INN863RWRepublic Airways Inc · Carmel, INN864RWRepublic Airways Inc · Carmel, INN865RWRepublic Airways Inc · Carmel, INN875RWDelta Air Lines Inc · Atlanta, GAN878RWDelta Air Lines Inc · Atlanta, GAN879RWDelta Air Lines Inc · Atlanta, GAN880RWDelta Air Lines Inc · Atlanta, GAN882RWDelta Air Lines Inc · Atlanta, GAN979RPRepublic Airways Inc · Carmel, IN
Back to AD 2005-07-22