AD 2007-13-13
Registered aircraft · 688
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-13-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-13-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-13-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-13-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.
N520SYSkywest Airlines Inc · St George, UTN521SYSkywest Airlines Inc · Saint George, UTN536SYRegistered aircraftN-number assigned (import), not yet registeredN544SYRegistered aircraftN-number assigned (import), not yet registeredN545SYRegistered aircraftN-number assigned (import), not yet registeredN546SYRegistered aircraftN-number assigned (import), not yet registeredN603CZDelta Air Lines Inc · Atlanta, GAN604CZDelta Air Lines Inc · Atlanta, GAN607CZDelta Air Lines Inc · Atlanta, GAN610CZDelta Air Lines Inc · Atlanta, GAN613CZDelta Air Lines Inc · Atlanta, GAN614CZDelta Air Lines Inc · Atlanta, GAN620QXHorizon Air Industries Inc · Seattle, WAN622QXHorizon Air Industries Inc · Seattle, WAN623QXHorizon Air Industries Inc · Seattle, WAN624QXHorizon Air Industries Inc · Seatac, WAN625QXHorizon Air Industries Inc · Seattle, WAN626QXHorizon Air Industries Inc · Seattle, WAN627QXHorizon Air Industries Inc · Seattle, WAN628QXHorizon Air Industries Inc · Seattle, WAN629QXHorizon Air Industries Inc · Seattle, WAN630QXHorizon Air Industries Inc · Seatac, WAN631QXHorizon Air Industries Inc · Seattle, WAN632QXHorizon Air Industries Inc · Seattle, WAN633QXHorizon Air Industries Inc · Seatac, WAN634QXHorizon Air Industries Inc · Seattle, WAN635QXHorizon Air Industries Inc · Seatac, WAN636QXHorizon Air Industries Inc · Seattle, WAN637QXHorizon Air Industries Inc · Seatac, WAN638QXHorizon Air Industries Inc · Seattle, WAN638RWRepublic Airways Inc · Carmel, INN639QXHorizon Air Industries Inc · Seatac, WAN639RWRepublic Airways Inc · Carmel, INN640RWRepublic Airways Inc · Carmel, INN641QXHorizon Air Industries Inc · Seattle, WAN641RWRepublic Airways Inc · Carmel, INN642QXHorizon Air Industries Inc · Seatac, WAN642RWRepublic Airways Inc · Carmel, INN643QXHorizon Air Industries Inc · Seattle, WAN644QXHorizon Air Industries Inc · Seatac, WAN645QXHorizon Air Industries Inc · Seattle, WAN646QXHorizon Air Industries Inc · Seattle, WAN647QXHorizon Air Industries Inc · Seatac, WAN647RWRepublic Airways Inc · Carmel, INN648QXHorizon Air Industries Inc · Seattle, WAN648RWRepublic Airways Inc · Carmel, INN649QXHorizon Air Industries Inc · Seatac, WAN650QXHorizon Air Industries Inc · Seattle, WAN651QXHorizon Air Industries Inc · Seattle, WAN652MKHorizon Air Industries Inc · Seatac, WA
Back to AD 2007-13-13