Skip to content

Registered aircraft · 187

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

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:2021-20-18') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2021-20-18') ORDER BY n_number

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:2021-20-18')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2021-20-18')
  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:2021-20-18')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2021-20-18')
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.

N112FCFlorida Dept Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2023 · S/N 15032 N115FCFlorida Depart Of Agriculture & Consumer Services · Tallahassee, FLBuilt 2023 · S/N 15033 N116FCFlorida Department Of Agriculture & Consumer Srvs · Tallahassee, FLBuilt 2023 · S/N 15034 N117FCFlorida Department Of Agriculture And · Tallahassee, FLBuilt 2024 · S/N 15035 N118FCFlorida Dept Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2022 · S/N 15020 N119LWValiair Ltd Co Trustee · Casper, WYBuilt 2008 · S/N 14721 N119NYCity Of New York · Wappingers Falls, NYBuilt 2017 · S/N 14945 N119VETrixie Racer LLC · Chicago, ILS/N 14737 N120NYCity Of New York · Wappingers Falls, NYS/N 14950 N215JRValiair Lc Trustee · Casper, WYS/N 14723 N237EFLeonardo Helicopters US Corp · Philadelphia, PAS/N 15037 N260KPFbr Aviation Inc · Fort Lauderdale, FLBuilt 2025 · S/N 15036 N281MCDodson International Parts Inc · Rantoul, KSBuilt 2022 · S/N 15017 N306LGMed-Trans Corp · Denton, TXBuilt 2015 · S/N 14839 N319MCMercy Flight Central Holding LLC · Canandaigua, NYBuilt 2022 · S/N 15018 N330JNBristow LLC · Lake Charles, LABuilt 2006 · S/N 14510 N351LLCritical Care Services Inc DBA · Blaine, MNBuilt 2014 · S/N 14819 N352LLCritical Care Services Inc DBA · Blaine, MNBuilt 2014 · S/N 14820 N353LLCritical Care Services Inc DBA · Blaine, MNBuilt 2014 · S/N 14821 N354LLCritical Care Services Inc DBA · Blaine, MNBuilt 2014 · S/N 14822 N355LLCritical Care Services Inc DBA · Blaine, MNBuilt 2014 · S/N 14823 N356LLCritical Care Services Inc DBA · Blaine, MNBuilt 2014 · S/N 14824 N357LLCritical Care Services Inc DBA · Blaine Gton, MNBuilt 2015 · S/N 14835 N358LLCritical Care Services Inc DBA · Blaine, MNBuilt 2016 · S/N 14902 N359LLCritical Care Services Inc DBA · Blaine, MNBuilt 2017 · S/N 14934 N360LLCritical Care Services Inc DBA · Blaine, MNBuilt 2018 · S/N 14948 N365LLCritical Care Services Inc DBA · Blaine, MNBuilt 2013 · S/N 14812 N367LLCritical Care Services Inc DBA · Blaine, MNBuilt 2015 · S/N 14832 N368LLCritical Care Services Inc DBA · Blaine, MNBuilt 2015 · S/N 14833 N42KMKhm Holdings LLC · Winnabow, NCBuilt 2012 · S/N 14786 N516LFBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 14782 N546LFBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 14802 N556LFWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 14804 N566LFWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 14808 N586LFHaynes Life Flight LLC · Wetumpka, ALBuilt 2013 · S/N 14809 N596LFHaynes Life Flight LLC · Wetumpka, ALBuilt 2013 · S/N 14810 N648SHAltus Aviation Management · Las Vegas, NVNon-citizen corporation, flight hours not reportedBuilt 2018 · S/N 14954 N651MCMercy Flight Central Holding LLC · Canandaigua, NYBuilt 2023 · S/N 15021 N656LFTroy Equipment Holdings LLC · Houston, TXBuilt 2014 · S/N 14826 N663SSLeonardo Helicopters US Corp · Philadelphia, PABuilt 2019 · S/N 14938 N669SSLeonardo Helicopters US Corp · Philadelphia, PABuilt 2019 · S/N 14940 N703SHNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15833 N705SHNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15834 N706SHNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15835 N712MCMercy Flight Central Holding LLC · Canandaigua, NYBuilt 2022 · S/N 15008 N726LFBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 14836 N756LFBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 14837 N776LFKeybank Na · Superior, COBuilt 2016 · S/N 14846 N786LFKeybank Na · Superior, COBuilt 2016 · S/N 14847 N78LFMercy Health Life Flight Network LLC · Toledo, OHBuilt 2019 · S/N 14963

Back to AD 2021-20-18