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.

N38177Archer Enterprises Corp · Ossining, NYBuilt 1977 · S/N 28-7790526N38178Gcs Aero LLC · Laramie, WYBuilt 1977 · S/N 28-7790527N38195Inspiration Aviation Ministries · Waterville, MEBuilt 1977 · S/N 28-7716230N38197Anderson Loran · Cooperstown, NDBuilt 1977 · S/N 28-7716231N381BTPiper Aircraft Inc · Vero Beach, FLS/N 28010085N381DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843844N381GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881429N381LJBlue Rudder Aviatoin LLC · Excelsior, MNBuilt 2002 · S/N 2843540N381NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881666N38200Hauzer Alex · Golden, COBuilt 1977 · S/N 28R-7737083N38211Watford Aeroservice LLC · Watford City, NDBuilt 1977 · S/N 28-7716232N38214Mora Steven T · Corning, CABuilt 1977 · S/N 28-7790530N38248Plane Training LLC · Rapid City, SDBuilt 1977 · S/N 28-7716234N38250Elkins John H · Lancaster, MABuilt 1977 · S/N 28-7790531N38254Syracuse Flying Club Inc · Fayetteville, NYBuilt 1977 · S/N 28-7790534N38256Ringler Neil H · Baldwinsville, NYBuilt 1977 · S/N 28R-7737085N38265Recipe System US Inc · Torrance, CABuilt 1977 · S/N 28-7716236N38267Andy Mack Management LLC · Wilmington, DEBuilt 1977 · S/N 28-7716237N38273Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-7737086N3827MFox James Douglas · Pittsburg, ILBuilt 1978 · S/N 28-7890335N38291Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7716240N38293L & A Bennett Second Family L P · Renton, WAS/N 28-7790537N38294Aerograzmar LLC · Bloomfield, NJBuilt 1977 · S/N 28R-7737087N382BTPiper Aircraft Inc · Vero Beach, FLS/N 28010086N382DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843845N382NDUniversity Of North Dakota · Grand Forks, NDBuilt 2024 · S/N 2881828N38311Archair Enterprises Inc · Wilmington, DEBuilt 1977 · S/N 28-7790538N38316Meriden Aviation Center LLC · Meriden, CTBuilt 1977 · S/N 28-7716241N38319Fronduto Cody Michael · Fort Pierce, FLBuilt 1977 · S/N 28-7790539N3831MWebster Mark A · Chino Hills, CABuilt 1978 · S/N 28R-7837138N38321Owens Richard Salad Inc · St Simons Is, GABuilt 1977 · S/N 28-7790541N38324De Oliveira Antonio J · Fuquay Varina, NCBuilt 1977 · S/N 28-7790535N38356John Prosock Machine Inc · Quakertown, PABuilt 1977 · S/N 28-7790543N38357Carr Mark · Wshngtn Ct Hs, OHS/N 28-7790544N38373Outbound Aviation LLC · Dover, DEBuilt 1977 · S/N 28-7716247N38382Syracuse Aviation LLC · Cicero, NYBuilt 1977 · S/N 28R-7737091N38394Wall Jeffrey L · Goffstown, NHBuilt 1977 · S/N 28-7790548N383DANew Mexico Flying Eagle Inc · Tucson, AZBuilt 2003 · S/N 2844098N383GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881118N383NDUniversity Of North Dakota · Grand Forks, NDBuilt 2024 · S/N 2881829N383PTFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 2881603N38409Straub Craig W · San Martin, CABuilt 1977 · S/N 28-7790255N38411N38411 LLC · Bellevue, WABuilt 1977 · S/N 28-7790356N38412Rekaa Enterprises LLC · Paragould, ARBuilt 1977 · S/N 28-7716251N38421Sale Reported · Ephrata, WASale reported, pending cancellationBuilt 1977 · S/N 28-7790551N38433Global Aviation Corp · Farmingdale, NYBuilt 1977 · S/N 28-7716254N38434Wheeler Jeffrey Scott · Hampstead, NCBuilt 1977 · S/N 28-7790553N38457Registration Pending · Phoenix, AZRegistration pendingBuilt 1977 · S/N 28R-7737094N38480Klose Frank · Rochester Hills, MIBuilt 1977 · S/N 28-7716260N38483Kdrd Holdings LLC · Texas City, TXS/N 28-7790556
Back to AD 2016-07-21