AD 2012-05-09

Registered aircraft · 6,155

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:2012-05-09')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-05-09')
  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.

N1017GAustin Byrum Andrew C · Rogers, ARBuilt 1981 · S/N 25-0547N1017LTop Gun Aviation Inc · Quinnesec, MIBuilt 1981 · S/N 25-0615N1017MOstroff Nathaniel S · Summerland Key, FLBuilt 1981 · S/N 25-0564N1018CSotek LLC · Cheyenne, WYS/N 24-1110N1018MWilliams Arthur L · Amherst, OHBuilt 1990 · S/N 24-3153N1018VHack Mark A · Floyds Knobs, INBuilt 2005 · S/N 29-0350N10194N10194 Aviation LLC · Pleasant Hill, CAS/N 24-3109N1019CHunter James A · Elizabeth City, NCBuilt 2001 · S/N 29-0271N1019ZJb Air LLC · Lindsay, OKBuilt 2004 · S/N 290324N101DXPatierno David M · Templeton, CABuilt 2000 · S/N 29-0221N101ECAtkinson Justin Shane · Fairbanks, AKBuilt 1978 · S/N 24-0593N101KUBarton Bruce R · Richmond, KYBuilt 1979 · S/N 24-0778N101MURed Bird And Outlaw LLC · Schertz, TXBuilt 1994 · S/N 24-3335N101TLojek Donald W · Boise, IDBuilt 1964 · S/N 2887N101UKInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 250631N1020AIrving Donald J · Deland, FLBuilt 2003 · S/N 29-0316N1021KVranjes Miron · Mercer Island, WAS/N 24-3104N1021URegistered aircraftBuilt 2004 · S/N 29-0325N1022UCivil Precast Corp · Ridgeland, MSBuilt 2007 · S/N 31-0066N1024CLarsen Johannes · Sterling, MAS/N 24-1113N1026ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 290321N1026CMooney Howard James Jr · Lake Wales, FLBuilt 1995 · S/N 27-0203N1026FDeramus Eugene T · Garden Ridge, TXBuilt 2004 · S/N 29-0326N1026NMartin Jonathan W · Carnesville, GABuilt 1994 · S/N 24-3337N1026UMooneylust LLC · Springfield, MOBuilt 1989 · S/N 25-1215N1027TEye Candy Aircraft LLC · Jacksonville, FLBuilt 2003 · S/N 290307N1029BStonewall Aviation LLC · Stillwater, OKBuilt 1982 · S/N 24-1336N1029MHarris Charles T Trustee · Thousand Oaks, CAS/N 29-0315N102ATEpling Bryan J · Upper Arlington, OHBuilt 1981 · S/N 24-1217N102PLLenker Mark R · Grand Prairie, TXBuilt 1991 · S/N 24-3233N102PTNion LLC · New Century, KSBuilt 2008 · S/N 29-0511N102TNTailwinds And Blue Skies LLC · Wilmington, DEBuilt 2008 · S/N 31-0102N102YMKern Jason S Trustee · New Braunfels, TXBuilt 1996 · S/N 24-3389N1030RThomas Leasing Enterprise LLC · Troy, MIBuilt 2001 · S/N 29-0278N1031RKeller Paul M · Sanford, NCBuilt 1989 · S/N 25-1216N1032XSunrise Aviation Inc Trustee · Wilmington, DEBuilt 2007 · S/N 31-0074N1032ZHoffman Curtis A · Marlborough, MABuilt 2003 · S/N 290309N1033QKuhn Marcus J · Madison, WIBuilt 2003 · S/N 29-0310N1034SSchlueter Jeffrey · Fernandina Beach, FLBuilt 2006 · S/N 29-0456N1035NHiggins Michael S · Palatine, ILBuilt 2003 · S/N 29-0305N10368S-A Clark Aviation LLC · Fort Smith, ARBuilt 2002 · S/N 29-0286N1036RYork Aviation LLC · Asheboro, NCBuilt 2003 · S/N 29-0302N1036USandor Pethes · Terre Haute, INBuilt 1996 · S/N 24-3386N1038WMulrooney Brian P · Minnetonka, MNBuilt 1981 · S/N 24-1118N1039BG & M Aviation LLC · Kokomo, INBuilt 1981 · S/N 24-1119N1039KMorris Eric K · Strasburg, VAS/N 24-3110N1039SJohnson Robert E Jr · Southport, NCBuilt 2003 · S/N 29-0318N103DXThornton Aaron Dewayne · Lubbock, TXBuilt 2008 · S/N 31-0100N103PTAvion Guy LLC · Baton Rouge, LABuilt 1975 · S/N 22-1252N103TNArthur Lee E · Spring, TXBuilt 2008 · S/N 31-0103
Back to AD 2012-05-09