AD 2012-10-07
Registered aircraft · 501
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:2012-10-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:2012-10-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:2012-10-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:2012-10-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.
N913XJDelta Air Lines Inc · Atlanta, GAN914XJDelta Air Lines Inc · Atlanta, GAN915FJSkywest Airlines Inc · St George, UTN915XJDelta Air Lines Inc · Atlanta, GAN916XJDelta Air Lines Inc · Atlanta, GAN917XJDelta Air Lines Inc · Atlanta, GAN918FJSkywest Airlines Inc · St George, UTN918XJDelta Air Lines Inc · Atlanta, GAN919FJSkywest Airlines Inc · St George, UTN919XJDelta Air Lines Inc · Atlanta, GAN920FJSkywest Airlines Inc · St George, UTN920XJDelta Air Lines Inc · Atlanta, GAN921FJBank Of Utah Trustee · Salt Lake City, UTN921XJDelta Air Lines Inc · Atlanta, GAN922FJBank Of Utah Trustee · Salt Lake City, UTN922XJDelta Air Lines Inc · Atlanta, GAN923FJBank Of Utah Trustee · Salt Lake City, UTN923XJDelta Air Lines Inc · Atlanta, GAN924FJBank Of Utah Trustee · Salr Lake City, UTN924XJDelta Air Lines Inc · Atlanta, GAN925FJBank Of Utah Trustee · Salt Lake City, UTN925XJDelta Air Lines Inc · Atlanta, GAN926LRBank Of Utah Trustee · Salt Lake City, UTN926XJDelta Air Lines Inc · Atlanta, GAN927LRBank Of Utah Trustee · Salt Lake City, UTN927XJDelta Air Lines Inc · Atlanta, GAN928LRBank Of Utah Trustee · Salt Lake City, UTN928XJDelta Air Lines Inc · Atlanta, GAN929LRBank Of Utah Trustee · Salt Lake City, UTN929XJDelta Air Lines Inc · Atlanta, GAN930XJDelta Air Lines Inc · Atlanta, GAN931LRBank Of Utah Trustee · Salt Lake City, UTN931XJDelta Air Lines Inc · Atlanta, GAN932LRBank Of Utah Trustee · Salt Lake City, UTN932XJDelta Air Lines Inc · Atlanta, GAN933LRBank Of Utah Trustee · Salt Lake City, UTN933XJDelta Air Lines Inc · Atlanta, GAN934XJDelta Air Lines Inc · Atlanta, GAN935LRBank Of Utah Trustee · Salt Lake City, UTN935XJDelta Air Lines Inc · Atlanta, GAN936XJDelta Air Lines Inc · Atlanta, GAN937XJDelta Air Lines Inc · Atlanta, GAN945LRBank Of Utah Trustee · Salt Lake City, UTN946LRSkywest Airlines Inc · Saint George, UTN947LRSkywest Airlines Inc · St George, UTN948LRSkywest Airlines Inc · St George, UTN94PQDelta Air Lines Inc · Atlanta, GAN950LRSkywest Airlines Inc · St George, UTN951LRSkywest Airlines Inc · St George, UTN95PQDelta Air Lines Inc · Atlanta, GA
Back to AD 2012-10-07