AD 2012-23-02
Registered aircraft · 79
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-23-02')
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-23-02')
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-23-02') 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-23-02') 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.
N6JEEurotec Vertical Flight Solutions LLC · Eudora, KSN6VZLeonardo Helicopters US Corp · Philadelphia, PAN71NMNorth Memorial Health Care · Brooklyn Center, MNN73AZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN749SDRocklyn Leasing LLC · Duluth, GAN75GGA109s LLC · Pinecrest, FLN770PATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN7ADEurotec Vertical Flight Solutions LLC · Eudora, KSN7UCRegistration Pending · Greenwood Village, CORegistration pendingN80NYWgb Holdings LLC · Sparta, NJN81NMNorth Memorial Health Care · Brooklyn Center, MNN820FTBristow LLC · Lake Charles, LAN827KUEurotec Vertical Flight Solutions LLC · Eudora, KSN85KVKhosla Ventures LLC · San Jose, CAN901CMLifeflight Of Maine LLC · Bangor, MEN901EMLifeflight Of Maine LLC · Bangor, MEN90NMNorth Memorial Health Care · Minneapolis, MNN910LBBristow LLC · Lake Charles, LAN91LFInternational Defense & Aerospace Group LLC · Glen Mills, PAN91SVSaint Vincent Mercy Medical Center · Toledo, OHN921LFLife Flight Network LLC · Aurora, ORN922LFEurotec Vertical Flight Solutions LLC · Eudora, KSN923LFEurotec Vertical Flight Solutions LLC · Eudora, KSN92LFEurotec Vertical Flight Solutions LLC · Eudora, KSN94AHEurotec Vertical Flight Solutions LLC · Eudora, KSN95RZSt Vincent Mercy Medical Center · Toledo, OHN962JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN963JERegistered aircraftAssigned (import), pending cancellationN9CWGran Cosecha LLC · Lake Wales, FL
Back to AD 2012-23-02