Registered aircraft · 5,443

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:2016-07-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:2016-07-21') 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:2016-07-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:2016-07-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:2016-07-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:2016-07-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.

N5665VWanigas Leasing Corporation · Saginaw, MIBuilt 1977 · S/N 28-7790491 N566KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843889 N5676VDave Simpson Aviation Inc · Escondido, CABuilt 1977 · S/N 28-7790494 N5679VAir Nautica LLC · Dublin, GAS/N 28-7716197 N5680VTime To Fly LLC · Cleveland, MSBuilt 1977 · S/N 28-7716198 N5681VNewell & Sons · Roxboro, NCBuilt 1977 · S/N 28-7790495 N5682VSgm Contractors LLC · Great Falls, VABuilt 1977 · S/N 28-7790496 N5689VStardust Aviation LLC · Farmingdale, NYBuilt 1977 · S/N 28-7790498 N568EParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020236 N568KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843890 N5697VPray Aviation Dr · Augusta, KSS/N 28-7716203 N56EKQuailair LLC Trustee · MichelstadtS/N 2890145 N56NAHampden Aviation Services Inc · Northampton, MABuilt 1979 · S/N 28-8016073 N5705VFalcon Aviation Inc · Clarence Center, NYBuilt 1977 · S/N 28-7790500 N570SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881401 N570TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881870 N570UOhio University · Albany, OHBuilt 2001 · S/N 2844054 N571TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881871 N572KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843900 N572TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881872 N573JAYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 28020264 N575BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881958 N575SDBlue Sky Aviation LLC · Menominee, MIBuilt 2023 · S/N 2881633 N576KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843937 N578KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843901 N578SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881402 N57CKCarefree Aviation LLC · Lock Haven, PABuilt 2014 · S/N 2844149 N57DROrellana Werner Jr · Richmond, TXS/N 28-8016035 N57JAN57ja LLC · Quakertown, PABuilt 1979 · S/N 28-7990270 N57MARegent Trust Co Trustee · Wichita, KSBuilt 2022 · S/N 2881556 N5804FNoonday Sun LLC · Kensington, OHBuilt 1976 · S/N 28-7790134 N5804VNationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7716204 N5806VJolliff Herbert H · Independence, ORBuilt 1977 · S/N 28-7716205 N580GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881191 N580JAHot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020080 N580UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020165 N5812VRoark Gidion T Jr · New Roads, LAS/N 28-7790501 N5813VRose William A · Chesapeake, VABuilt 1977 · S/N 28-7790502 N5817FWicker John E · Lexington, NCBuilt 1976 · S/N 28-7790136 N581KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843916 N582BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881959 N583CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881132 N5846FDunning Steve L · Hopkinsville, KYBuilt 1976 · S/N 28-7790138 N5849FGng LLC · Arlington, INBuilt 1976 · S/N 28-7790139 N584SShobe Andrew S A · Clarksville, MDBuilt 1977 · S/N 28R7737112 N584SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881403 N5857VHague Parkerson B · Virginia Beach, VAS/N 28-7716207 N5859VHaney Paul · Navarre, FLBuilt 1977 · S/N 28-7790504 N585AWChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843934 N585GEWayne Mogg Inc · Parker, AZFirst renewal noticeBuilt 2018 · S/N 2881009

Back to AD 2016-07-21