AD 2000-05-08
Registered aircraft · 695
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-05-08')
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-05-08')
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-05-08') 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-05-08') 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.
N724UWUmb Bank Na Trustee · Salt Lake City, UTN725UWUmb Bank Na Trustee · Salt Lake City, UTN730AVUmb Bank Na Trustee · Salt Lake City, UTN730USAmerican Airlines Inc · Fort Worth, TXN732USAmerican Airlines Inc · Fort Worth, TXN733UWAmerican Airlines Inc · Fort Worth, TXN737USBank Of Utah Trustee · Salt Lake City, UTN738USBank Of Utah Trustee · Salt Lake City, UTN740UWBank Of Utah Trustee · Salt Lake City, UTN741UWBank Of Utah Trustee · Salt Lake City, UTN742PSBank Of Utah Trustee · Salt Lake City, UTN744PBank Of Utah Trustee · Salt Lake City, UTN745VJBank Of Utah Trustee · Salt Lake City, UTN746UWBank Of Utah Trustee · Salt Lake City, UTN747UWBank Of Utah Trustee · Salt Lake City, UTN748UWBank Of Utah Trustee · Salt Lake City, UTN749USBank Of Utah Trustee · Salt Lake City, UTN750UWBank Of Utah Trustee · Salt Lake City, UTN751UWBank Of Utah Trustee · Salt Lake City, UTN752USBank Of Utah Trustee · Salt Lake City, UTN753USBank Of Utah Trustee · Salt Lake City, UTN754UWBank Of Utah Trustee · Salt Lake City, UTN755USBank Of Utah Trustee · Salt Lake City, UTN756USBank Of Utah Trustee · Salt Lake City, UTN757UWBank Of Utah Trustee · Salt Lake City, UTN758USBank Of Utah Trustee · Salt Lake City, UTN760USBank Of Utah Trustee · Salt Lake City, UTN762USUmb Bank Na Trustee · Salt Lake City, UTN763USUmb Bank Na Trustee · Salt Lake City, UTN764USUmb Bank Na Trustee · Salt Lake City, UTN765USUmb Bank Na Trustee · Salt Lake City, UTN766USUmb Bank Na Trustee · Salt Lake City, UTN767UWUmb Bank Na Trustee · Salt Lake City, UTN768USUmb Bank Na Trustee · Salt Lake City, UTN769USUmb Bank Na Trustee · Salt Lake City, UTN770UWUmb Bank N A Trustee · Salt Lake City, UTN771XFWilmington Trust Co Trustee · Wilmington, DEN772XFWilmington Trust Co Trustee · Wilmington, DEN773XFWilmington Trust Co Trustee · Wilmington, DEN774XFWilmington Trust Co Trustee · Wilmington, DEN775XFWilmington Trust Co Trustee · Wilmington, DEN776XFWilmington Trust Co Trustee · Wilmington, DEN778XFBank Of Utah Trustee · Salt Lake City, UTN801AWU S Bank Na Trustee · Boston, MAN801UAUnited Airlines Inc · Chicago, ILN802AWU S Bank Na Trustee · Boston, MAN802UAUnited Airlines Inc · Chicago, ILN803AWU S Bank Na Trustee · Boston, MAN803UAUnited Airlines Inc · Chicago, ILN804AWU S Bank Na Trustee · Boston, MA
Back to AD 2000-05-08