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.
N811STNaval Air Systems Command · Patuxent River, MDN814WFRed Hawk Management LLC · Ocilla, GAN81NMNorth Memorial Health Care · Brooklyn Center, MNN820FTBristow LLC · Lake Charles, LAN822MMBristow LLC · Lake Charles, LAN823STNaval Air Systems Command · Patuxent River, MDN824STLeonardo Helicopters US Corp · Philadelphia, PAN826STNaval Air Systems Command · Patuxent River, MDN827KUEurotec Vertical Flight Solutions LLC · Eudora, KSN828STNaval Air Systems Command · Patuxent River, MDN829STNaval Air Systems Command · Patuxent River, MDN830STNaval Air Systems Command · Patuxent River, MDN831STNaval Air Systems Command · Patuxent River, MDN832STNaval Air Systems Command · Patuxent River, MDN835STNaval Air Systems Command · Patuxent River, MDN836STNaval Air Systems Command · Patuxent River, MDN837STNaval Air Systems Command · Patuxent River, MDN839STNaval Air Systems Command · Patuxent River, MDN843STNaval Air Systems Command · Patuxent River, MDN845STNaval Air Systems Command · Patuxent River, MDN846STNaval Air Systems Command · Patuxent River, MDN847STNaval Air Systems Command · Patuxent River, MDN848STNaval Air Systems Command · Patuxent River, MDN849STNaval Air Systems Command · Patuxent River, MDN852STNaval Air Systems Command · Patuxent River, MDN853STNaval Air Systems Command · Patuxent River, MDN854STNaval Air Systems Command · Patuxent River, MDN859STNaval Air Systems Command · Patuxent River, MDN85KVKhosla Ventures LLC · San Jose, CAN860STNaval Air Systems Command · Patuxent River, MDN861STNaval Air Systems Command · Patuxent River, MDN863STNaval Air Systems Command · Patuxent River, MDN869STNaval Air Systems Command · Patuxent River, MDN882STNaval Air Systems Command · Patuxent River, MDN883STNaval Air Systems Command · Patuxent River, MDN890PAAgustawestland Philadelphia Corp · Philadelphia, PANon-citizen corporation, flight hours not reportedN901CMLifeflight Of Maine LLC · Bangor, MEN901EMLifeflight Of Maine LLC · Bangor, MEN901LFLifeflight Of Maine LLC · Bangor, MEN901WMLifeflight Of Maine · Bangor, MEN901XMLifeflight Of Maine LLC · Bangor, MEN901YMLifeflight Of Maine LLC · Bangor, MEN902JANaval Air Systems Command · Patuxent River, MDN903JANaval Air Systems Command · Patuxent River, MDN903STNaval Air Systems Command · Patuxent River, MDN906JANaval Air Systems Command · Patuxent River, MDN908STNaval Air Systems Command · Patuxent River, MDN909JANaval Air Systems Command · Patuxent River, MDN909STNaval Air Systems Command · Patuxent River, MDN90NMNorth Memorial Health Care · Minneapolis, MN
Back to AD 2020-21-21