Skip to content

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.

N600AVMountain Top Aviation Inc · Ebensburg, PABuilt 1978 · S/N 28-7916229 N600HJRavotti Air LLC · Leechburg, PABuilt 1978 · S/N 28-7990004 N600PFEastern Aviation Corp · Whitestone, NYBuilt 1977 · S/N 28-7816109 N6011FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020090 N6015FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020091 N6018FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020092 N601EAExecutive Air Transport Inc · Norton Shores, MIBuilt 1978 · S/N 28-7916124 N601FTSanson Paul H · Deland, FLBuilt 1989 · S/N 2841195 N602FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7716056 N602PCJ & P Aviation LLC · Plymouth, MABuilt 1979 · S/N 28-7990581 N6030FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020093 N6031FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020094 N6035FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020095 N603APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843769 N603BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020286 N603CEGulf Coast Premier Aviation LLC · Cape Coral, FLBuilt 2023 · S/N 2881660 N603EAOakmere Leasing LLC · Muskegon, MIBuilt 1978 · S/N 28-7916117 N603FTFlorida Institute Of Technology · Melbourne, FLBuilt 1979 · S/N 28-7916427 N6041HEstes Billy J · Irvine, KYBuilt 1977 · S/N 28-7890201 N6045FVee Two Inc · Merritt Island, FLBuilt 2022 · S/N 28020096 N604ACFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2014 · S/N 2843756 N604FFFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 2881604 N604FTFlorida Institute Of Technology · Melbourne, FLBuilt 1985 · S/N 28-8516078 N604GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881192 N6050FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020097 N6053FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020149 N6057HAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1977 · S/N 28-7816216 N6058FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020150 N6059HOverholtzer Mark S · Salem, ORBuilt 1977 · S/N 28-7816217 N605FFFf22 LLC · Scottsdale, AZS/N 2881605 N605FTOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1989 · S/N 2841198 N605GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881193 N6063HHagerstown Flying Club · Williamsburg, INBuilt 1977 · S/N 28-7890203 N6065HNoble Mark · Memphis, TNBuilt 1977 · S/N 28-7890204 N6066HFlaps Inc · Cincinnati, OHBuilt 1977 · S/N 28-7890205 N6067HMilford Aviation Inc · Hoffman Estates, ILBuilt 1977 · S/N 28R-7837050 N6069FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020151 N606EAOakmere Leasing LLC · Norton Shores, MIBuilt 1979 · S/N 28-7916477 N6077EAir Fleet Holdings LLC · Addison, TXBuilt 2022 · S/N 2881548 N6078FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020152 N607EABlue Horizons Flying Club Inc · Perrysburg, OHBuilt 1980 · S/N 28-8116140 N607FTFlorida Institute Of Technology · Melbourne, FLBuilt 1979 · S/N 28-7916271 N607NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881185 N607PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841215 N6080HShealy Horace L Jr · Chesapeake, VAS/N 28-7890207 N6081HFlathers George William II · Palmyra, VABuilt 1977 · S/N 28-7890208 N6083HAerotyne Aviation LLC · Omaha, NEBuilt 1977 · S/N 28R-7837052 N6085FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020153 N6089FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020154 N608ACBas Part Sales LLC · Greeley, COBuilt 2014 · S/N 2843758

Back to AD 2016-07-21