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.

N2959MHanneman Robert · Claremore, OKBuilt 1977 · S/N 28-7890281 N2959QParis Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-7916585 N2959USmart5 LLC · Kissimmee, FLBuilt 1979 · S/N 28-7916588 N295BCWieler Jacob · Petty, TXS/N 28-7916435 N295FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2018 · S/N 2844178 N2960DRed Baron Rentals LLC · Jacksonville, FLBuilt 1979 · S/N 28-7916590 N2961BHyldburg Aviation · Plymouth, MABuilt 1979 · S/N 28-7916591 N2961WKrauss Solutions LLC · Debary, FLBuilt 1979 · S/N 28-7916594 N2962UFlake Philip · Pearland, TXS/N 28-7916598 N2965WFly On LLC · Boise, IDBuilt 1979 · S/N 28-8090003 N2969SJorgensen Richard J · Vail, AZBuilt 1979 · S/N 28-8090013 N296CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881008 N296MAHot Wings Aviation LLC · Fishers, INBuilt 2026 · S/N 28020266 N296MGGeorgia Aviation Authority · Eastman, GABuilt 2017 · S/N 2844168 N2971VSorensen John · Cape May Ch, NJS/N 28-8016001 N2972CHoosier Aviation LLC · Terre Haute, INBuilt 1979 · S/N 28-8016003 N2972YHopkins Larry G · Malabar, FLS/N 28-8016006 N2973KCrown Heights Footcare · Brooklyn, NYS/N 28-8016007 N2973UMobug LLC · Montgomery, TXBuilt 1979 · S/N 28-8016009 N2973WWarrior Aircraft Corp · Sturgis, MIS/N 28-8016010 N2973XJones Jeffrey S · Roseburg, ORBuilt 1979 · S/N 28-8016011 N2973YValiair Limited Co Trustee · Casper, WYBuilt 1979 · S/N 28-8016012 N2974B4m Aircraft Services LLC · Santa Rosa Beach, FLBuilt 1979 · S/N 28-8090020 N2974NDes Moines Flying Club LLC · Indianola, IABuilt 1979 · S/N 28-8090022 N2974TTiger Services Inc · Lawrenceville, GABuilt 1979 · S/N 28-8090024 N297CBCalifornia Baptist University · Riverside, CAS/N 2881917 N297MGGeorgia Aviation Authority · Eastman, GABuilt 2017 · S/N 2843863 N298MGGeorgia Aviation Authority · Eastman, GABuilt 2017 · S/N 2843864 N299MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2844181 N299PAH & H Aviation LLC · Dunn, NCBuilt 1999 · S/N 2843230 N29TEBessarab Alex · Portland, ORBuilt 1979 · S/N 28-7916397 N2BYMostello Andrew · Harvard, MABuilt 1977 · S/N 28R-7737129 N2PXBliss James · Corpus Christi, TXBuilt 1977 · S/N 28-7816211 N30009Mock Joseph R · Huntsville, TXBuilt 1978 · S/N 28-7816539 N30012Wfc Aviation Inc · Johnstown, PABuilt 1978 · S/N 28-7916073 N30015N30015 LLC · Saunderstown, RIBuilt 1978 · S/N 28-7990079 N3001KHauck Drew Steven · Buffalo, MNBuilt 1978 · S/N 28-7990241 N3001TSluka Christopher J · San Diego, CABuilt 1979 · S/N 28-7990319 N3001WLexington Flying Club Inc · Lexington, KYBuilt 1979 · S/N 28-7990356 N30020Frieders Farm Corp · Waterman, ILBuilt 1978 · S/N 28-7990080 N30024Druid Aire LLC · Wilmington, DEBuilt 1978 · S/N 28R-7837311 N3002BDenton Charles W · San Juan, PRBuilt 1978 · S/N 28-7916123 N3002MHarth Kai H · Manassas, VABuilt 1978 · S/N 28-7816327 N30034Archer 30034 LLC · Ray Township, MIS/N 2843576 N3003BEhrlich David · Chico, CAS/N 28-7990133 N3003KPayne Michael E · Woodlawn, ILBuilt 1978 · S/N 28-7990243 N3003QTampa Bay Aviation Inc · Clearwater, FLBuilt 1977 · S/N 28-7790430 N3005KEast Valley Flyers LLC · Chandler, AZBuilt 1978 · S/N 28-7990246 N3005TSkala Frank M · Wurtsboro, NYS/N 28-7916384 N30063King Air Inc · Naknek, AKBuilt 1978 · S/N 28-7990082

Back to AD 2016-07-21