OpenAirDocs.org
AD 2016-05-13

Registered aircraft · 3,126

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-05-13')
    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-05-13')
  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.

N541PBUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 541N542AXAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-192N5431MReach Air Medical Services LLC · Santa Rosa, CABuilt 2002 · S/N LJ-1673N543AXAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-219N543GATriple A LLC · Savannah, GABuilt 1999 · S/N LJ-1558N543HCMay Cattle Co LLC · Campbellton, TXBuilt 2001 · S/N LJ-1620N545WBLamy LLC · Alexandria, LABuilt 1996 · S/N 107N5466RNorthwest Turbine LLC · Spokane, WABuilt 1985 · S/N TJ-497N546LMAero Air LLC · Hillsboro, ORBuilt 1985 · S/N BB1235N547PAcqr Leasing LLC · Lake Shore, MNBuilt 1997 · S/N FL185N548MBSomers Charles · Hillsboro, ORBuilt 1988 · S/N 548N549LGWestern Cooperative Co · Alliance, NEBuilt 2022 · S/N T660-169DCN550AHHall Aircraft · Wynne, ARBuilt 2004 · S/N T34HG-104N550CRCwr Holdings LLC · Wilmington, DEBuilt 2001 · S/N 4697031N550GCSouth Delta Aviation LLC · Grace, MSBuilt 1997 · S/N 402A-1037N550HETeufel Nursery Inc · Hillsboro, ORBuilt 1968 · S/N 001N550HZMaytag David D Jr · Cave Creek, AZBuilt 1972 · S/N 007N550KGSheffield Flying Service LLC · Iron City, GABuilt 2008 · S/N T65-021DCN550PHHall Aircraft · Wynne, ARBuilt 2011 · S/N T65HG-025DCN550VAKingrey William S III · Richmond, TXBuilt 2004 · S/N T34HG-106N5512BAircraft Structures International Corp · Enid, OKBuilt 1992 · S/N 208B0299N551CNChoctaw Nation Of Oklahoma · Durant, OKBuilt 1993 · S/N LJ-1347N552CBonmark Aviation LLC · Scottsdale, AZBuilt 2026 · S/N 46020116N552PZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1990 · S/N 01900008N553RWFoxtrot Sierra Bravo LLC · Scott City, KSBuilt 2004 · S/N 553N554MARkjm LLC · Superior, NEBuilt 2023 · S/N 802A-1011N554SCChristmas Flying Service LLC · Shelby, MSBuilt 2011 · S/N 602-1205N555HJFlycarolina King Air Partners LLC · Charlotte, NCBuilt 1994 · S/N LJ-1378N555VWTp Aviation LLC · Auburn, ALBuilt 1993 · S/N LJ-1330N555XYNware Aviation Inc · Dover, NHBuilt 1997 · S/N LJ-1488N556ALEaglemed LLC · Wichita, KSBuilt 1999 · S/N BB-1670N557CFH & G Farms Inc · Corcoran, CABuilt 2016 · S/N 802A-0668N557MAMeyers Aerial Service LLC · Superior, NEBuilt 2025 · S/N 802A-1246N557PCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 557N558BVDt Air LLC · Picayune, MSBuilt 1998 · S/N FL-223N558LAWilmot Airplane Ventures LLC · Mer Rouge, LABuilt 2024 · S/N 802A-1158N559CASky West Aviation Inc Trustee · Albuquerque, NMS/N 213N559PBEmpty Rain Aviation LLC · Broomfield, COBuilt 2004 · S/N 559N55BKPc 12 LLC · Sterling, VABuilt 1996 · S/N 160N55RPneuma Aviation LLC · New Orleans, LABuilt 1976 · S/N 31T-7620055N55WFIcm Inc · Colwich, KSBuilt 1985 · S/N LJ-1114N55WPRichardson Farms Outfitters Inc · Pittsfield, ILBuilt 1995 · S/N 127N55ZGDixie Painting & Sandblasting Inc · Northport, ALBuilt 2001 · S/N 4697082N55ZREuroaviaition Inc Trustee · KematenBuilt 1999 · S/N LJ-1566N560HPRjc Rental Properties LLC · San Diego, CABuilt 2001 · S/N 4697045N561KGGehrair LLC · Palm Beach Gardens, FLBuilt 1991 · S/N FA-212N561STCharter Fx LLC · Crestview, FLBuilt 2004 · S/N 561N561TBPembrook Aviation LLC · Los Angeles, CABuilt 1993 · S/N 90N561ZAZulu Air LLC · Opa Locka, FLS/N BB1180N5626YHillcrest Air LLC · Jackson, TNBuilt 1991 · S/N FL-43
Back to AD 2016-05-13