AD 2020-21-21
Registered aircraft · 308
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:2020-21-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2020-21-21')
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:2020-21-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2020-21-21') 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.
N910LBBristow LLC · Lake Charles, LAN913JANaval Air Systems Command · Patuxent River, MDN915JANaval Air Systems Command · Patuxent River, MDN915STNaval Air Systems Command · Patuxent River, MDN918JANaval Air Systems Command · Patuxent River, MDN919STNaval Air Systems Command · Patuxent River, MDN91LFInternational Defense & Aerospace Group LLC · Glen Mills, PAN91SVSaint Vincent Mercy Medical Center · Toledo, OHN920JANaval Air Systems Command · Patuxent River, MDN920JDBristow LLC · Lake Charles, LAN921LFLife Flight Network LLC · Aurora, ORN922JANaval Air Systems Command · Patuxent River, MDN922LFEurotec Vertical Flight Solutions LLC · Eudora, KSN923LFEurotec Vertical Flight Solutions LLC · Eudora, KSN924STNaval Air Systems Command · Patuxent River, MDN925STNaval Air Systems Command · Patuxent River, MDN926STNaval Air Systems Command · Patuxent River, MDN92LFEurotec Vertical Flight Solutions LLC · Eudora, KSN930JANaval Air Systems Command · Patuxent River, MDN932JANaval Air Systems Command · Patuxent River, MDN933JANaval Air Systems Command · Patuxent River, MDN934JANaval Air Systems Command · Patuxent River, MDN934STNaval Air Systems Command · Patuxent River, MDN935JANaval Air Systems Command · Patuxent River, MDN935STNaval Air Systems Command · Patuxent River, MDN936JANaval Air Systems Command · Patuxent River, MDN936STNaval Air Systems Command · Patuxent River, MDN937JANaval Air Systems Command · Patuxent River, MDN939JANaval Air Systems Command · Patuxent River, MDN940JANaval Air Systems Command · Patuxent River, MDN941STNaval Air Systems Command · Patuxent River, MDN942JANaval Air Systems Command · Patuxent River, MDN943JANaval Air System Command · Patuxent River, MDN944JANaval Air Systems Command · Patuxent River, MDN944STNaval Air Systems Command · Patuxent River, MDN945STNaval Air Systems Command · Patuxent River, MDN946JANaval Air Systems Command · Patuxent River, MDN946STNaval Air Systems Command · Patuxent River, MDN947JANaval Air Systems Command · Patuxent River, MDN947STNaval Air Systems Command · Patuxent River, MDN948STNaval Air Systems Command · Patuxent River, MDN949STNaval Air Systems Commnad · Patuxent River, MDN94AHEurotec Vertical Flight Solutions LLC · Eudora, KSN952STNaval Air Systems Command · Patuxent River, MDN953JANaval Air Systems Command · Pat, MDN955STNaval Air Systems Command · Patuxent River, MDN956JANaval Air Systems Command · Patuxent River, MDN956STNaval Air Systems Command · Patuxent River, MDN958JANaval Air Systems Command · Patuxent River, MDN959STNaval Air Systems Command · Patuxent River, MD
Back to AD 2020-21-21