OpenAirDocs.org
AD 2016-07-21

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
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.

N38492Toureau John H · Chesterfield, MIBuilt 1977 · S/N 28-7716261N38494Hannon Joseph S · Franklin, NHBuilt 1977 · S/N 28-7716262N384BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010038N384DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843846N384GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881430N384HSClear Prop LLC · Murfreesboro, TNBuilt 1977 · S/N 28-7790550N384NDJmfb Enterprises LLC · Concord, NCBuilt 2003 · S/N 2844095N38517Stillway Dennis Trustee · Vallejo, CABuilt 1977 · S/N 28-7790558N38522Radcliffe Joshua Kyle · Atlanta, GAS/N 28-7816180N38549Cohesive Aviation LLC · Gilford, NHS/N 28-7716268N38553Cherry Hill Aviation Inc · Freetown, INBuilt 1977 · S/N 28-7790563N3855MPramik Edward J · Norton, OHBuilt 1978 · S/N 28-7816381N38564Ck Leasing Services LLC · Wilmington, DEBuilt 1977 · S/N 28R-7737097N38565Olson Michael S · Ellsworth, KSFirst renewal noticeBuilt 1977 · S/N 28R-7737098N38577Global Aviation Corp · Farmingdale, NYBuilt 1977 · S/N 28-7716201N38587Swihart Painting LLC · Bolivar, MOBuilt 1977 · S/N 28R-7737100N3858MMachias Auto Parts Inc · Jonesport, MEBuilt 1978 · S/N 28-7816628N38599Collum Aviation LLC · Milton, FLS/N 28-7716271N3859MWhite Roger L · Wallins Creek, KYS/N 28-7890336N385DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843847N38603Flight Share LLC · Charlotte, NCBuilt 1977 · S/N 28-7790570N38605Registration Pending · Kalispell, MTRegistration pendingBuilt 1977 · S/N 28R-7737102N38628Maxair Inc · Coxs Creek, KYBuilt 1977 · S/N 28-7790572N38629Red Tail Scholarship Foundation · Tuskegee, ALBuilt 1977 · S/N 28-7790573N3862MN3862m LLC · Provo, UTS/N 28-7890337N38632Tappan Michael L · Miamisburg, OHBuilt 1977 · S/N 28R-7737103N3864MAscent Aviation LLC · Van Nuys, CABuilt 1978 · S/N 28-7890338N38655Wensmann Joel · Sartell, MNBuilt 1977 · S/N 28R-7737105N38656Allen James R · Olympia, WABuilt 1977 · S/N 28-7716272N38657W I F A (Washington International Flight Acad) LLC · Gaithersburg, MDBuilt 1977 · S/N 28-7790574N38694Chapman Daniel H · Yucaipa, CABuilt 1977 · S/N 28-7790576N38696Lake Area Technical College · Watertown, SDBuilt 1977 · S/N 28-7790577N386DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843848N386NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881678N38700Universal Aviators Academy Inc · El Monte, CABuilt 1978 · S/N 28-7890001N38716Spartan Aviation Group LLC · Williamsburg, VABuilt 1977 · S/N 28R-7737109N38717Meiller Richard S · Kill Devil Hills, NCBuilt 1977 · S/N 28R-7737110N38718Vgw LLC · Morgantown, WVBuilt 1977 · S/N 28R-7737111N38733Lauren Erick · Hollister, CABuilt 1977 · S/N 28-7790580N38735Schulz Lewis E III · Sand Springs, OKBuilt 1977 · S/N 28-7790581N38771Bmaf LLC · Lewes, DEBuilt 1977 · S/N 28R-7737116N38773Gustafson David · Watertown, SDBuilt 1977 · S/N 28R-7737117N38777Medsker Doug S · Graham, MOBuilt 1977 · S/N 28-7816181N38786Johnson David M · South Deerfield, MABuilt 1977 · S/N 28-7790588N38804H And R Aviation LLC · Jonesboro, ARBuilt 1977 · S/N 28-7790589N38836Angelle Martin · Slidell, LABuilt 1977 · S/N 28-7790592N38840Abdelmegid Shokria M · Desert Hot Springs, CABuilt 1977 · S/N 28-7790594N38841Savate Lloyd S · Berkeley, CABuilt 1977 · S/N 28-7790596N38842Scud Rat LLC · Valparaiso, INBuilt 1977 · S/N 28-7790597N38852Hesston College · Hesston, KSBuilt 1977 · S/N 28-7790601
Back to AD 2016-07-21