AD 2000-22-07
Registered aircraft · 442
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:2000-22-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:2000-22-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:2000-22-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:2000-22-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.
N680NKUmb Bank Na Trustee · Salt Lake City, UTN681NKSpirit Airlines LLC · Dania Beach, FLN682NKSpirit Airlines LLC · Dania Beach, FLN683NKSpirit Airlines LLC · Dania Beach, FLN684NKSpirit Airlines LLC · Dania Beach, FLN685NKSpirit Airlines LLC · Dania Beach, FLN686NKSpirit Airlines LLC · Dania Beach, FLN687NKSpirit Airlines LLC · Dania Beach, FLN690NKSpirit Airlines LLC · Dania Beach, FLN691NKSpirit Airlines LLC · Dania Beach, FLN692NKSpirit Airlines LLC · Dania Beach, FLN693NKSpirit Airlines LLC · Dania Beach, FLN694NKSpirit Airlines LLC · Dania Beach, FLN696NKSpirit Airlines LLC · Dania Beach, FLN703JBJetblue Airways Corp · Long Island City, NYN705JBJetblue Airways Corp · Long Island City, NYN706JBJetblue Airways Corp · Long Island City, NYN708JBJetblue Airways Corp · Long Island City, NYN709JBJetblue Airways Corp · Long Island City, NYN712JBJetblue Airways Corp · Long Island City, NYN715JBJetblue Airways Corp · Long Island City, NYN730AVUmb Bank Na Trustee · Salt Lake City, UTN746JBJetblue Airways Corp · Long Island City, NYN760JBJetblue Airways Corp · Long Island City, NYN763JBJetblue Airways Corp · Long Island, NYN766JBJetblue Airways Corp · Long Island City, NYN768JBJetblue Airways Corp · Long Island City, NYN775JBJetblue Airways Corp · Long Island City, NYN779JBJetblue Airways Corp · Long Island City, NYN784JBJetblue Airways Corp · Long Island City, NYN789JBJetblue Airways Corp · Long Island, NYN793JBJetblue Airways Corp · Long Island City, NYN794JBJetblue Airways Corp · Long Island City, NYN796JBJetblue Airways Corp · Long Island City, NYN804JBJetblue Airways Corp · Long Island City, NYN805JBJetblue Airways Corp · Long Island City, NYN806JBJetblue Airways Corp · Long Island City, NYN807JBJetblue Airways Corp · Long Island City, NYN809JBJetblue Airways Corp · Long Island City, NYN817UAUnited Airlines Inc · Chicago, ILN821JBJetblue Airways Corp · Long Island City, NYN827JBJetblue Airways Corp · Long Island City, NYN828JBJetblue Airways Corp · Long Island City, NYN834JBJetblue Airways Corp · Long Island City, NYN871UAUmb Bank Na Trustee · Salt Lake City, UTN872UAUmb Bank Na Trustee · Salt Lake City, UTN873UAUmb Bank Na Trustee · Salt Lake City, UTN875UAUnited Airlines Inc · Chicago, ILN876UAUnited Airlines Inc · Chicago, ILN877UAUmb Bank Na Trustee · Salt Lake City, UT
Back to AD 2000-22-07