AD 2007-19-13
Registered aircraft · 2,446
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:2007-19-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-19-13')
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:2007-19-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-19-13') 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.
N602NKBank Of Utah Trustee · Salt Lake City, UTN603JBJetblue Airways Corp · Long Island City, NYN603KWAlta 767 Spv LLC · Salt Lake City, UTN603NKBank Of Utah Trustee · Salt Lake City, UTN60491Umb Bank Na Trustee · Salt Lake City, UTN604AWUmb Bank Na Trustee · Salt Lake City, UTN604KWAlta 767 Spv LLC · Salt Lake City, UTN604NKBank Of Utah Trustee · Salt Lake City, UTN605JBJetblue Airways Corp · Long Island City, NYN605KWAlta 767 Spv LLC · Salt Lake City, UTN605NKWells Fargo Trust Co Na Trustee · Columbia, MDN606JBJetblue Airways Corp · Long Island City, NYN606KWAlta 767 Spv LLC · Salt Lake City, UTN606NKWells Fargo Trust Co Na Trustee · Columbia, MDN607AZAmazon.Com Services LLC · Seattle, WAN607JBJetblue Airways Corp · Long Island City, NYN607NKWilmington Trust Co Trustee · Wilmington, DEN608JBJetblue Airways Corp · Long Island City, NYN608NKBank Of Utah Trustee · Salt Lake City, UTN60958Umb Bank Na Trustee · Salt Lake City, UTN609NKBank Of Utah Trustee · Salt Lake City, UTN611NKWells Fargo Trust Co Na Trustee · Columbia, MDN612JBJetblue Airways Corp · Long Island City, NYN612NKRegistration Pending · Salt Lake City, UTRegistration pendingN613AZAmazon.Com Services LLC · Seattle, WAN613JBJetblue Airways Corp · Long Island City, NYN613NKBank Of Utah Trustee · Salt Lake City, UTN614NKUmb Bank Na Trustee · Salt Lake City, UTN615JBJetblue Airways · Long Island City, NYN615NKBank Of Utah Trustee · Salt Lake City, UTN616NKUmb Bank Na Trustee · Salt Lake City, UTN617AZAmazon.Com Services LLC · Seattle, WAN617NKBank Of Utah Trustee · Salt Lake City, UTN617USLogistic Air Inc · Reno, NVN618JBJetblue Airways Corp · Long Island City, NYN618NKUmb Bank Na Trustee · Salt Lake City, UTN618USLogistic Air Inc · Reno, NVN619AZAmazon.Com Services LLC · Seattle, WAN619NKWells Fargo Trust Co Na Trustee · Columbia, MDN620NKBank Of Utah Trustee · Salt Lake City, UTN621JBJetblue Airways · Long Island City, NYN621NKWilmington Trust Co Trustee · Wilmington, DEN622NKWilmington Trust Co Trustee · Wilmington, DEN623JBJetblue Airways Corp · Long Island City, NYN623NKWilmington Trust Co Trustee · Wilmington, DEN624JBJetblue Airways Corp · Long Island City, NYN624NKWilmington Trust Co Trustee · Wilmington, DEN625HRTryst 767 LLC · San Juan, PRN625JBJetblue Airways Corporation · Long Island City, NYN625NKUmb Bank Na Trustee · Salt Lake City, UT
Back to AD 2007-19-13