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.

N1041CHelzer Timothy · Tucson, AZBuilt 2003 · S/N 270321N1041GN1041g LLC · Charlotte, NCBuilt 1981 · S/N 25-0567N10422Jackson Benjamin Tillman · Rancho Mirage, CABuilt 2004 · S/N 29-0323N1043HValiair Limited Co Trustee · Casper, WYBuilt 2007 · S/N 31-0058N1043ZJones Property Services Inc · Pelham, ALBuilt 1982 · S/N 24-1337N1044VTigers Air Inc · Fairfax Station, VABuilt 2003 · S/N 29-0317N1045FOpc Consulting LLC · Hickory Corners, MIBuilt 2001 · S/N 29-0273N1045XServaty Frank R · Canyon Lake, TXBuilt 2000 · S/N 29-0232N10469Airscout LLC · Valdosta, GABuilt 2004 · S/N 29-0336N1046UMetzel Peyton S · Libertyville, ILBuilt 1989 · S/N 24-3114N1047AHolt Sheet Metal Inc · Durango, COBuilt 1981 · S/N 25-0571N1047LMcneill Philip · Reston, VABuilt 2003 · S/N 29-0320N1048DDumbravo Dustin C · Yorktown, VABuilt 2001 · S/N 27-0315N1049TRoberts Kevin C · Athens, GABuilt 2003 · S/N 27-0319N104PBMountain Flight LLC · Missoula, MTBuilt 1974 · S/N 20-0035N1050BNine1on Industries LLC · Helena, MTBuilt 2001 · S/N 27-0312N1050QCouch Kelly P · Elk Grove, CABuilt 2000 · S/N 27-0310N1051KMcclure Paul D · Birmingham, ALBuilt 2002 · S/N 29-0285N1051YChristophersen Hunter · Fairway, KSBuilt 1989 · S/N 24-3116N1053LKutzleb Michael K · Fernandina Beach, FLBuilt 2000 · S/N 29-0261N1053UEricson Kurt A · Gulfport, FLS/N 24-3117N1054CCumberland Curtis · Union Bridge, MDBuilt 2003 · S/N 29-0296N1054KBondy William G · Miami Beach, FLBuilt 2000 · S/N 29-0266N1056TTierno Patrick Louis · Seaford, DES/N 30-0065N105PAPeck John A Jr · Shady Shores, TXBuilt 1997 · S/N 29-0107N1064UHenline Aircraft Sales LLC · Hickory, NCBuilt 1993 · S/N 24-3295N1065NEmmons James W · Bay Minette, ALBuilt 1993 · S/N 24-3296N1065SGiacobbe Francesco · Severna Park, MDBuilt 1994 · S/N 27-0187N1065WCartwright Alexander Brooks · New Paris, INBuilt 1994 · S/N 27-0188N1065XRobert C Ripley Mdpc · Nashville, TNBuilt 1993 · S/N 24-3299N1066UBurgoyne Wallace Carr Jr · Spring, TXBuilt 1994 · S/N 29-0005N1067FNorklun Matthew J · Wainscott, NYS/N 24-3125N1067GKmeck Joseph J · Erie, COBuilt 1990 · S/N 24-3174N1067WGraham James M · Minneapolis, MNBuilt 1998 · S/N 24-3415N1068AWest Texas Aviation LLC · San Angelo, TXBuilt 1989 · S/N 24-3133N1068GCanopy Ministries Inc · Mountain City, TNBuilt 2004 · S/N 29-0328N1068RG & H Aviation · Louisville, KYBuilt 1992 · S/N 24-3246N1068XChapel Hill Flying Club Ind DBA · Sanford, NCBuilt 1993 · S/N 24-3302N1069GWilliams Jack · Lake Havasu City, AZBuilt 1989 · S/N 24-3135N106QIntegrity Aero LLC · Boerne, TXS/N 25-1208N106TNSecond Wind Enterprises LLC · Atlanta, GABuilt 2008 · S/N 31-0106N1070ZSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1990 · S/N 25-1222N10719Florida Independent Truck Repair Inc · Greeneville, TNBuilt 1990 · S/N 24-3141N1071UCrowder Zachary · Merritt Island, FLBuilt 1989 · S/N 24-3140N1071YBreaux John Jr · Minden, NVS/N 24-1124N10725N22154 Inc · Wilmington, DES/N 24-3143N1072NStephens Donald G · Huntington Beach, CAFirst renewal noticeBuilt 1981 · S/N 24-1125N1072YRyan Aaron · Wichita Falls, TXBuilt 1995 · S/N 24-3369N1072ZCorbett Henry E · Salem, ORBuilt 1981 · S/N 24-1126N1073GProfessional Flyers Corporation · Wilmington, DEBuilt 1994 · S/N 27-0191
Back to AD 2012-05-09