AD 2016-06-03
Registered aircraft · 726
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:2016-06-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-06-03')
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:2016-06-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-06-03') 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.
N660AWUS Bank Na Trustee · Boston, MAN660NKSpirit Airlines LLC · Dania Beach, FLN661AWU S Bank Na Trustee · Boston, MAN661JBJetblue Airways Corp · Long Island, NYN661NKSpirit Airlines LLC · Dania Beach, FLN662AWUS Bank National Association Trustee · Boston, MAN662JBJetblue Airways Corp · Long Island City, NYN662NKSpirit Airlines LLC · Dania Beach, FLN663AWUS Bank Na Trustee · Boston, MAN663JBJetblue Airways Corp · Long Island City, NYN663NKSpirit Airlines LLC · Dania Beach, FLN664AWU S Bank Na Trustee · Boston, MAN664NKSpirit Airlines LLC · Dania Beach, FLN665AWU S Bank Na Trustee · Boston, MAN665JBJetblue Airways Corp · Long Island City, NYN665NKSpirit Airlines LLC · Dania Beach, FLN667AWU S Bank Na Trustee · Boston, MAN667NKSpirit Airlines LLC · Dania Beach, FLN668AWU S Bank Na Trustee · Boston, MAN668NKSpirit Airlines LLC · Dania Beach, FLN668SDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN669AWU S Bank Na Trustee · Boston, MAN669NKSpirit Airlines LLC · Dania Beach, FLN670NKSpirit Airlines LLC · Dania Beach, FLN671NKSpirit Airlines LLC · Dania Beach, FLN672NKSpirit Airlines LLC · Dania Beach, FLN673AWBank Of Utah Trustee · Salt Lake City, UTN673NKSpirit Airlines LLC · Dania Beach, FLN674NKSpirit Airlines LLC · Dania Beach, FLN675NKSpirit Airlines LLC · Dania Beach, FLN678NKSpirit Airlines LLC · Dania Beach, FLN679AWBank Of Utah Trustee · Salt Lake City, UTN679NKUmb Bank Na Trustee · Salt Lake City, UTN680AWUmb Bank N A Trustee · Salt Lake City, UTN680NKUmb 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, NY
Back to AD 2016-06-03